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

2009-02-23 Thread Fred Williams
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

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

2009-02-23 Thread jose isaias cabrera
"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 the

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

2009-02-23 Thread jose isaias cabrera
essage- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of jose isaias cabrera >> Sent: Sunday, February 22, 2009 1:57 PM >> To: General Discussion of SQLite Database >> Subject: [sqlite] Windows XP: How Can I Get High

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

2009-02-23 Thread jose isaias cabrera
ght that there could be something that I can do. Thanks. > > 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 1:57 PM > To: General Dis

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

2009-02-22 Thread Matthew L. Creech
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 folks, do they each need to

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

2009-02-22 Thread jose isaias cabrera
"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 the

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

2009-02-22 Thread Alexey Pechnikov
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 lis

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

2009-02-22 Thread P Kishor
red > > -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 1:57 PM > To: General Discussion of SQLite Database > Subject: [sqlite] Windows XP: How Can I Ge

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

2009-02-22 Thread Fred Williams
saias cabrera Sent: Sunday, February 22, 2009 1:57 PM To: General Discussion of SQLite Database Subject: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite Greetings! I have a very small database, well, 62.1 MB (65,150,976 bytes), and when I do a search on it, the CPU only goes to 7% a

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

2009-02-22 Thread jose isaias cabrera
Greetings! I have a very small database, well, 62.1 MB (65,150,976 bytes), and when I do a search on it, the CPU only goes to 7% and 12% at the most. Sometimes it takes a few seconds to return with the results. I am not complaining about the 5-10 seconds of the returning of the result, but I