How to improve the speed of database opeartion
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   parag_dharmadhikari
Posted On:   Friday, August 2, 2002 12:52 AM

Hi all



In my application which is based on JSP and JavaBeans (not EJB), in database there are going to be information about more than 7000 files and when I will query lot of data is going to be retrived by the application. Now that will cause the application to slow down. And hence I am looking for method by which I can improve on the speed of database transcations.

Can anybody help me.




Regards

Parag

Re: How to improve the speed of database opeartion

Posted By:   Milan_Mogin  
Posted On:   Tuesday, August 13, 2002 04:52 PM

Allow users to refine queries in order

to get smaller result set ( it is not likely

that somebody will want to look at 7000 results

at the same time.

You can also bring results back in "chunks" ( maybe
20 - 30 results per page ). Depending on a database

you are using there might be SQL commands to asist with

this, for example PostgreSQL has LIMIT command that

would only bring back specified part of result.



Indexes help for search speed ;-)



Milan

Web Development
About | Sitemap | Contact