Microsoft Access / Php : comparison

[Anon]

Hi,

I want to have access to a remote MySQL Database, and to get some information from it.

Using Microsoft Access, the query takes about 20 secs to be executed.
Using exactly the same query in a Php script (using the functions 'odbc_exec' and 'odbc_fetch_row'), it takes ... 3minutes!!!!

Has anybody an idea about why there is such a difference?

[Anon]

I have some ideas, but you should go look at the Microsoft Knowledge Base about using (and tuning use of) ODBC and the Jet engine.

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com

[Anon]

I didn't found that much there :-(, apart from the latest version of Microsoft Jet 4.0 ... which I had already downloaded.

So, if you have any ideas, please don't hesitate to share them. Thanks.

[bastien]

Please post your query...it might be that the DB is being loaded by having the links between tables being created every time....

Bastien

[Anon]

Here we are :

SELECT dbo_Volumes.VolumeId, dbo_Prods.ProdZoneId
FROM ((dbo_Volumes INNER JOIN (dbo_ProdContainers INNER JOIN dbo_VolumePages ON dbo_ProdContainers.VolumePageId = dbo_VolumePages.VolumePageId) ON dbo_Volumes.VolumeId = dbo_VolumePages.VolumeId) INNER JOIN dbo_ProdZones ON dbo_ProdContainers.ProdContainerId = dbo_ProdZones.ProdContainerId) INNER JOIN dbo_Prods ON dbo_ProdZones.ProdZoneId = dbo_Prods.ProdZoneId
WHERE (((dbo_Volumes.VolumeId)=12345));