[RESOLVED] Query Optimization

[Mr_Jezz]

In my PHP I perform the following query

$sql = "SELECT StatusId, Format(ActualReleaseDate,'dd/mm/yy') As ARDate, AssetName, Format(ActualReleaseDate,'mm') As ARMonth, Format(ActualReleaseDate,'yy') As ARYear, Format(ActualReleaseDate,'yymmdd') As ARDate1, Format(PredictedReleaseDate,'mm') As PRMonth, Format(PredictedReleaseDate,'yy') As PRYear, ReleaseNo, Format(PredictedReleaseDate,'dd/mm/yy') As PRDate, Format(PredictedReleaseDate,'yymmdd') As PRDate1, StatusId
FROM $query_name WHERE AssetName <> 'Change Request System' AND StatusId <> 4 ORDER BY AssetName, ReleaseNo";

I'm querying an Access DB, (no choice in this!). When I view the web page on which this query is run, the resulting table of results takes along time to load. I'm wondering if the 'Format()' stuff is really slowing it down, unfortunatly I need to do this as I need the date in a certain formats for use later on. Is there a better way of formatting these fields?

Any help would be appreciated.

[superwormy]

I doubt the formatting is slowing it down, but try it without the format() statements and see if its any better.

You might try and INDEX on 'StatusId or AssetName to speed things up too.