paul
|
| Posted: 02/14/2004, 11:01 AM |
|
Cross-posted from Codecharge-General
Hi there
ListBox Values which doesnt change often or never, can be listed in Codecharge/CS already.
In my gut feel, a Datasource Type=ListofValues and then in DataSource the list would be faster than a mySQL table with the listed values and calling it from the database everytime.
IOW, I would put Lists such as 1;YES;2;NO as well as Titles 1;mr;2;mrs;3;dr;4;prof etc rather in CC already instead of the table.
Am I right? I tried to test it, but have to few concurrent users to see a difference.
Any comments please.....
regards
Paul
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/14/2004, 11:36 AM |
|
Paul,
You can select "List of Values" to be used in a listbox, in both CC and CCS.
Though I rather didn't understand your comment about "differences".
Please describe what issues or differences you have experienced.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Paul
|
| Posted: 02/15/2004, 7:44 AM |
|
Quote peterr:
Paul,
You can select "List of Values" to be used in a listbox, in both CC and CCS.
Though I rather didn't understand your comment about "differences".
Please describe what issues or differences you have experienced.
Hi There
I cannot describe a difference as there is none. If I test the one or the other method, I do not see a difference. Maybe I should try a Load test.
What I was trying to ask:
There are two methods of populate values in a Listbox:
1. Having all the values listed in a specific table in a database.
2. Use DataSource with the values which I would have had in a table listed here.
My question is: which is the best as far as speed and reliability is concerned.
regards
Paul
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/15/2004, 1:19 PM |
|
Paul,
They are both reliable - there should be no difference in reliability.
They are both fast - there should be no difference in speed, unless you have several hundred listbox values.
The only downside to using the database/table is that the database will need to execute an additional SQL query, which is a factor in scalability, for example if your application will handle thousands of users.
Of course if you don't need to store something in the database then don't use it. The database has specific purpose of storing the dynamic data and you may need to decide how much and which data you want to store in your database. I probably wouldn't store Yes/No values in a database, but I would store Titles in it, so that they could be modified without changing the project/code.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Paul
|
| Posted: 02/17/2004, 6:26 AM |
|
Thank you!
|
|
|
|
|
 |
|
|
|
