> On Wed, Jan 20, 2010 at 6:24 PM, hi <hiralsmaill...@gmail.com> wrote: >> 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.
How are you currently getting the min/max values? What have you tried so far? One of many ways would be to precompute the min/max into a separate table and then query that table whenever you need the min/max. Regards, - Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
