Re: Local CDDB lookups

["Andy Powell" <Andy@xxxxxxx>]

Stuart,

DiskID and MyDiskNo are indexed.. should I index the track offsets too?

DiscOffsets fields are:
*DiskID
*MyDiskNo
TrackNumber
TrackOffset


A.

*********** REPLY SEPARATOR  ***********

On 19/03/01 at 17:18 Stuart Grimshaw wrote:

>You don't mention if you have any indexes on the field you are
searching?
>
>If not then that would speed the searches up no end.
>
>On Monday 19 March 2001 15:16 pm, you wrote:
>>
>> The database is an access (v7) database and has 4 tables
>>
>> 	DiscInfo
>> 	AlbumInfo
>> 	TrackInfo
>> 	TrackOffsets
>>
>>
>> DiskInfo Fields are:
>>
>> DiskID
>> MyDiskNo
>> DiskLength
>> TrackCount
>> DiskTitle
>>
>> AlbumInfo fields are:
>>
>> DiskID
>> MyDiskNo
>> ArtistFirstName
>> ArtistLastName
>> TrackCount
>> DiskTitle
>> DiskYear
>> GenreText
>>
>> TrackInfo fields are:
>> DiskID
>> MyDiskNo
>> TrackNumber
>> TrackTitle
>>
>> DiscOffsets fields are:
>> DiskID
>> MyDiskNo
>> TrackNumber
>> TrackOffset
>>
>> Any advice would be greatly appreciated....
>>
>> A.
>>
>>
>> --- Tag-it! v2.0 (c) Andy Powell ,1998,1999,2000...and beyond..
>>
>> Tell me what you believe and I'll tell you where you're going
wrong.
>>
>>
>>
>>
>>
>>
>> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>--
>                                ,,,
>                               (o o)
>===========================oOO==(_)==OOo==============================
>Stuart Grimshaw         www.schoolsnet.com          sg@xxxxxxx
>Special Projects Developer                            t: 07976 625221
>Schoolsnet LTD             .oooO  Oooo.               f: 0870 7060260
>===========================(   )==(   )===============================
>                            \ (    ) /
>                             \_)  (_/
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


--- Tag-it! v2.0 (c) Andy Powell ,1998,1999,2000...and beyond..

We are Craft Decor of Borg. Your money is for tile.