Vander Clock Stephane <svandercl...@yahoo.fr> писал(а) в своём письме Sat,  
11 Dec 2010 02:20:42 +0600:

> Hello,
>
> to limit the file fragmentation i want to increase the size of the
> database file (with the windows API function).
>
> Can i do this ?
>
> thanks you by advance
> stéphane

Not possible, I'm afraid. Besides, SQLite reads the data in random order
(especially if the data is indexed) anyway, so defragmenting it won't help  
much.
Wait until your data file is large enough, then use any OS tool to  
defragment it :)
But be prepared that inner contents of the data file will be still  
fragmented.

-- 
Regards,
Serge Igitov
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to