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.
- [sqlite] For Better Performance Sreedhar.a
- Re: [sqlite] For Better Performance Daniel Önnerby
- Re: [sqlite] For Better Performance John Stanton