the fastest, most efficient way to retrieve list of values from the db

**kulangotski** · 06-08-2011, 01:43 AM

hi! thanks for hitting this thread.

i was wondering what is the faster or fastest way to retrieve LOVs from the database. like for example, filling up a personal info form. then it has a html select object. that objects shows the list of countries (i guess that is more than two hundred). what i do is retrieve them values when the page loads and it does take a lot of time. AND THEN the user goes to another page that again contains a select that contains list of countries. then i would requery the same things just to populate the select object.

i was wondering what are other things or style or methods that i can try to use to get a LOVs from the database without or decreasing the amount of loading time for my page?

any suggestions would be appreciated

regards,
simon

**mine0926** · 06-08-2011, 05:17 AM

I do not fully understand your question or what you are trying to do but loading
200 records will not take that long. Have you tried it? If yes and if it take
long kindly post your related code. And how long it takes to load? Are you connecting to
local network?

**kulangotski** · 06-08-2011, 06:26 AM

hi! thanks for the response

well I think you understood the question just right. I just stated a single select as an example. but with the application we are currently building, there are a lot of values that are dependent on the database. like occupation, civil status and other LOVs.

what I am doing is when a page loads, It retrieves values to the db and thats every time a page loads. is that even efficient? or are there any methods which i can try to apply?

there are some other things that I suspect that makes application very slow but maybe I can see them some other time

thanks for the response.

regards,
simon

**mine0926** · 06-08-2011, 06:42 AM

Can you show your code or at least on how you connect to database including query so we can see if there is
somthing wrong. Are you connecting to server on local area network?

**kulangotski** · 06-08-2011, 07:03 AM

I am not connecting directly to the database. I am using business components for java as my persistence level I guess, I am not really sure.

As I am developing the web app, I am using the local network (it loads fast). but it was deployed yesterday to our companies site and I tried to connect to it while at home and it took some time. I was thinking that if other people might use it and it will take that amount of time, they would probably just get out of the page.

thanks again for replying

regards,
simon

**HeapSpace** · 06-08-2011, 09:12 AM

Perhaps share some of the workload with the database if you're using one that supports stored procedures ?

**kulangotski** · 06-08-2011, 09:42 AM

well thanks, i will try to do that to see if there would be any improvements in speed

**Tolls** · 06-08-2011, 10:03 AM

Originally Posted by kulangotski

As I am developing the web app, I am using the local network (it loads fast). but it was deployed yesterday to our companies site and I tried to connect to it while at home and it took some time. I was thinking that if other people might use it and it will take that amount of time, they would probably just get out of the page.

thanks again for replying

regards,
simon

That's nothing to do with getting the data from the database then. Presumably the server is near the database in both cases, so it's entirely down to the connection from your home to the server. Which implies either a slow connection or a large amount of data. Or a mix. Nothing to do with the database.

**kulangotski** · 06-08-2011, 02:36 PM

hey tolls, thanks for commenting out.

I never really thought how heavy the site is to load it all up. maybe that is the reason because my home internet connection is lame. maybe I would go to do some cleaning up and redeploy.

thanks for all the comments and suggestions. appreciate it

regards,
simon