Create an index on the field which you're getting min/max of. Then getting min/max will take some milliseconds.
Pavel On Wed, Jan 20, 2010 at 7:54 AM, hi <[email protected]> wrote: > Hi, > > For my application I am storing about "17700000" rows into sqlite table, and > when taking 'min' or 'max' it takes about ~7 to 10 seconds. > > Can you please suggest effective ways to get min/max values. > > Thank you in advance. > -Hiral > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
