Re: [sqlite] IS read data from sqlite cost too much time more than few tens or hundred Mega Bytes

2016-08-03 Thread Warren Young
On Aug 2, 2016, at 9:04 PM, 梨田 <1565050...@qq.com> wrote: > > I find when the data in database is larger than tens of mega bytes,it spends > more than 5~10s time to read it. If the time required to run a given SELECT call increases linearly as a function of the database size, you’re probably

Re: [sqlite] IS read data from sqlite cost too much time more than few tens or hundred Mega Bytes

2016-08-03 Thread Richard Hipp
On 8/2/16, 梨田 <1565050...@qq.com> wrote: > Dear friend: > >hi,i am a sqlite(3.7.7.1) user ,i have a question to > consult you.I find when the data in database is larger than tens of mega > bytes,it spends more than 5~10s time to read it. Is the time costed > reasonable?

[sqlite] IS read data from sqlite cost too much time more than few tens or hundred Mega Bytes

2016-08-03 Thread ????
Dear friend: hi,i am a sqlite(3.7.7.1) user ,i have a question to consult you.I find when the data in database is larger than tens of mega bytes,it spends more than 5~10s time to read it. Is the time costed reasonable? situation:one history table ,one