Hi!

songlist.ID is a primary key and I just make an index for
categorylist.songID as well as songlist.date_played and date_artist_played

This made the query execute in 2.4 seconds. A lot better...
But still not near the 0.1sec I'm used to with MySQL :(

Louis

----- Original Message -----
From: "Nick Upson" <uebridger@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, June 26, 2003 11:16 AM
Subject: Re: [firebird-support] Sloooow query


>
> songlist & categorylist do not appear to have any relevant indecies, both
> fields in
>
> songlist join categorylist on (songlist.ID = categorylist.songID)
>
> should be indexed
>
> >From: "Louis Louw" <louis@...>
>
> >Having a problem with a slow query in FireBird.
>
> _________________________________________________________________
> On the move? Get Hotmail on your mobile phone
http://www.msn.co.uk/msnmobile
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>