subject:"\[sqlite\] fasted way to get the min\/max"

Re: [sqlite] fasted way to get the min/max

2010-01-20 Thread Pavel Ivanov

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 wrote: > Hi, > > For my application I am storing about "1770" rows into sqlite table, and > when taking 'min'

[sqlite] fasted way to get the min/max

2010-01-20 Thread hi

Hi, For my application I am storing about "1770" 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