RE: [sqlite] To increase search speed

Method 3, normalization, is the right route but I think the implementation needs a little more work. First don't store both Artist ID and Artist Name in the Music table--only store the ID. This goes for AlbumID/Name and GenreID/Name as well. Then reorder the columns to put the integers first in

RE: [sqlite] To increase search speed

Thanks Raghavendra, We use sqlite statements for search. Best Regards, A.Sreedhar. -Original Message- From: RaghavendraK 70574 [mailto:[EMAIL PROTECTED] Sent: Saturday, August 18, 2007 10:13 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] To increase search speed use sqlite

Re: [sqlite] To increase search speed

I think method 3 shows the best promise: Obviously M4 is out since it is in memory only. Besides caching should help improve the performance. The qustion that begs to be asked is: What are your performance goals? And what are your performance numbers ie timings for each of the

Re: [sqlite] To increase search speed

use sqlite statements. regards ragha ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use