Re: Local CDDB lookups

[Stuart Grimshaw <stuart@xxxxxxx>]

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
===========================(   )==(   )===============================
\ (    ) /
\_)  (_/