How can I download data from Access Faster???

This is a very general question...I retrieve data from an accesss database using the DataBase toolbox functions and seems very slow. Is it there a way to perform faster queries /data extractions from Access to matlab? Thanks in advance for your help.

Answer 1

[Titus Edelhofer]

Hi Fernando,

there is no general answer to this general question. Some thoughts though:

• run the profiler to find out, where the most time is spent
• many little queries are generally slower then a few large ones, so instead of looping on queries try to combine them and analyze the result data afterwards.

Titus

Answer 2

[Fernando]

Thanks Titus for answering. I have run profiler and the time is consumed in the fetch comand. I use a query that attempts to retrieve all the data in one step, instead of many individual queries. But it gets to be very slow. I was wandering what I am doing wrong and what should I do.

[Titus Edelhofer]

Hi Fernando,

sorry, but then there will be not much you can do. The only thing: again, it depends on the size of the data. If the data is really (!) large, then it could be better again to divide the query into some (not many) smaller ones ...

Sorry for having no better news for you ...

Titus