I have tried changing the extension and also "copy my.db nul:". The
result does not change a bit. Still 40sec.
I also tried reading the file with fread before openning db connection like;
FILE* fp = fopen(fileName.c_str(), "rb");
if ( fp ) {
char pBuffer[1024*32];
while ( f
On Thu, 22 Jul 2010 10:44:50 -0500, "Black, Michael (IS)"
wrote:
>Wrongread the docs...if copy didn't do binary by default there would so
>many screwed up computers in the world
>
>
>http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/copy.mspx?mfr=true
>
>Us
Regarding win/dos COPY command and /b option:
Thanks for correcting me, Michael. I somehow thought that NUL being the target
would introduce some sort of "text affinity" but it's good to know the truth
instead.
___
sqlite-users mailing list
sqlite-us
10 10:18 AM
To: sqlite-users@sqlite.org
Subject: EXTERNAL:Re: [sqlite] Very Slow DB Access After Reboot on Windows
On Thu, 22 Jul 2010 08:56:31 -0400, "Griggs, Donald"
wrote:
>
>
>Regarding:
>Also...try doing a "copy my.db nul:" to get it cached once bef
On Thu, 22 Jul 2010 08:56:31 -0400, "Griggs, Donald"
wrote:
>
>
>Regarding:
>Also...try doing a "copy my.db nul:" to get it cached once before you use
> it.
>
>
>Am I right in thinking he may want to include the "/b" (binary) option so that
>the copy doesn't stop at the first nul byte?
>
Regarding:
Also...try doing a "copy my.db nul:" to get it cached once before you use
it.
Am I right in thinking he may want to include the "/b" (binary) option so that
the copy doesn't stop at the first nul byte?
copy /b my.db nul
___
anced Analytics Directorate
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin
Sent: Wed 7/21/2010 9:28 PM
To: General Discussion of SQLite Database
Subject: EXTERNAL:Re: [sqlite] Very Slow DB Access After Reboot on Wi
On 21 Jul 2010, at 4:56pm, Samet YASLAN wrote:
> I have a 30MB DB file with 4 tables.
> Execution time for a query is 1 sec normally but it is like 40 secs
> after restarting window.
> This seems to be related with file caching of Windows. The same source
> code does not cause this problem on L
I have a 30MB DB file with 4 tables.
Execution time for a query is 1 sec normally but it is like 40 secs
after restarting window.
This seems to be related with file caching of Windows. The same source
code does not cause this problem on Linux.
Any ideas?
--
*Samet YASLAN*
__
9 matches
Mail list logo