Please read the following pages:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows
Sreedhar.a wrote:
Hi,
I am using sqlite for meta data storage of audio files.
I am storing the sqlite database in hard disk.
The sector size of FAT file system is 512 bytes.
Hard disk rpm is 4200
Page size = 1K
cache size = 2k
The processor speed is 600 Mhz.
I am using joins method in sqlite.The records are the meta data information
of the audio files.
How i can improve my search and insertion speeds?
any change in the above parameters will help?
Thanks and Regards,
A.Sreedhar.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
