Re: [sqlite] For Better Performance

[John Stanton]

Your disk is slow (large latency).  Speeding that up to 7,500 or 15,000 
RPM will help.


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]
-

Re: [sqlite] For Better Performance

[Daniel Önnerby]

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]
-

[sqlite] For Better Performance

[Sreedhar.a]

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.