Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

--- with concurrency. Fred -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of jose isaias cabrera Sent: Sunday, February 22, 2009 10:41 PM To: pechni...@sandy.ru; General Discussion of SQLite Database Subject: Re: [sqlite] Windows XP: How Can I Get

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

"Alexey Pechnikov" wrote... > Hello! > > On Sunday 22 February 2009 22:56:36 jose isaias cabrera wrote: >> I have left everything default, so I have not set any PRAGMA settings. > > Try this: > pragma cache_size=1; > pragma page_size=16384; > vacuum; Wow, thanks. That did help. Cool, so

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

"P Kishor" wrote... > On Sun, Feb 22, 2009 at 2:14 PM, Fred Williams > wrote: >> Since the dawn of digital computers the CPU has been waiting on the I/O. >> Want to go faster? Get a faster mass storage device. Then your CPU >> usage >> will most likely jump all the

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

Funny... "Fred Williams" wrote... > Since the dawn of digital computers the CPU has been waiting on the I/O. > Want to go faster? Get a faster mass storage device. Then your CPU usage > will most likely jump all the way up to 9% - 14%! > > You can't believe what a 300 card per minute 80

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

On Sun, Feb 22, 2009 at 11:44 PM, jose isaias cabrera wrote: >> >> Try this: >> pragma cache_size=1; >> pragma page_size=16384; >> vacuum; > > Wow, thanks. That did help. Cool, so there was something that I could do. > Here is a question: this DB is shared by other

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

Hello! On Sunday 22 February 2009 22:56:36 jose isaias cabrera wrote: > I have left everything default, so I have not set any PRAGMA settings. Try this: pragma cache_size=1; pragma page_size=16384; vacuum; Best regards. ___ sqlite-users mailing

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

On Sun, Feb 22, 2009 at 2:14 PM, Fred Williams wrote: > Since the dawn of digital computers the CPU has been waiting on the I/O. > Want to go faster? Get a faster mass storage device. Then your CPU usage > will most likely jump all the way up to 9% - 14%! > > You can't

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

Since the dawn of digital computers the CPU has been waiting on the I/O. Want to go faster? Get a faster mass storage device. Then your CPU usage will most likely jump all the way up to 9% - 14%! You can't believe what a 300 card per minute 80 column card reader does to throughput when you use