MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Large database
Posted by: Albert Arul prakash Rajendran
Date: February 09, 2007 01:42AM

try to use recordset.getrows. this will send complete data in the result in the array and you can close the record set after get rows.

This will reduce the time delay in DB retrival.

Try to use indexing.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Large database
3749
Omar Khan
January 12, 2007 07:45AM
Re: Large database
2339
Albert Arul prakash Rajendran
February 09, 2007 01:42AM
Re: Large database
2212
Omar Khan
February 14, 2007 06:55AM
Re: Large database
2335
KimSeong Loh
February 14, 2007 06:47PM
Re: Large database
2254
Omar Khan
February 15, 2007 05:35AM
Re: Large database
2402
Sean Allin
February 15, 2007 05:13PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.