CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Listbox values, Use of ListofValues instead of table

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
Paul
Posted: 02/17/2004, 6:26 AM

Thank you!

8-)

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.