Re: [sqlite] performance question about select

Kei wrote: > Hi all, > > I have one performance question about select all and select all with limit > and offset. I do the test for measuring the time usage of the following > select statement. > > Task 1. select * from tablename order by name Task 2. select * from table > name order by name limit

[sqlite] performance question about select

Hi all, I have one performance question about select all and select all with limit and offset. I do the test for measuring the time usage of the following select statement. Task 1. select * from tablename order by name Task 2. select * from table name order by name limit 8 offset 0 and I have 50