RE: [sqlite] To increase search speed

Sent: Saturday, August 18, 2007 1:23 AM To: sqlite-users@sqlite.org Subject: [sqlite] To increase search speed Method 3: Joining Multiple tables. I have created 4 tables as follows; "create table ALBUMS (id integer primary key,Album text,unique(Album));"

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 mehtods

Re: [sqlite] To increase search speed

delete it! * - Original Message - From: "Sreedhar.a" <[EMAIL PROTECTED]> Date: Saturday, August 18, 2007 10:52 am Subject: [sqlite] To increase search speed > Hi > I am work

[sqlite] To increase search speed

Hi I am working in 3.3.6. I have created a table with 4 records with 12 fields as follows. "create table MUSIC (Id integer primary key, AlbumName text not null collate nocase,Track text not null collate nocase,ArtistName text not null collate nocase,URL text not null collate nocase , Duration