advise on using database operation

Hi

I have a client who need to need to check information from the mdb database file for the condition to pull in a metarial. In their code, they will open the database, read the information and close the database. Due to they have more than 500 process steps and 1000 of items, and hence each time the code is being executed it takes some time. At the end, it took me more 11 hours to run the model at the unlimited speed.

Is there anyone out there has any suggestion to what should I advise my client in speeding out the process of simulation?

By the way, I have used a better machine and has reduce the time from 2.5 days to 11 hours.

Thanks in advance!!

Regards

David

David,

Here are 2 remarks that I can think off:

First remark would be to not open en close the database because that is what is taking the time, but keep the database open en use a query everytime.

Other option would be to extract the needed data on reset and put it in a global table and use that to get the data from.

Steven,

Thanks. Most likely they need to try the first one as they still prefer the mdb file.

Thanks

David