On 11/30/06, Lloyd <[EMAIL PROTECTED]> wrote:
Hi, How much time can it take to perform 2000 selection queries on the same database ? Mostly the result set will contain only 1 raw. Is there is any way to improve the selection speed?
How on earth can anyone answer this question except for you. Just perform your query 2000 times and time it. Make sure you have indexed fields you are searching on. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation https://edu.osgeo.org/ ------------------------------------------------------------------------------------------------------- collaborate, communicate, compete ==================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
