By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

Access-ADP: tablesize and speed

P: n/a
Dear All,

I would like your oppinion on this

I have build a access-ADP that is running well for 3 years.
As tables grow in size some actions are slow.
In the code i used ADO, some command.executes but no stored procedures (
never done!)

a. tablesize (1/9/2003)
1. ORDER 37.214
2. ORDER_PHASE 353.198
3. ORDER_PROPERTY 162.667
4. PRODUCT 5.978
5. PRODUCT_PHASE 24.297
6. PRODUCT_PROPERTY 64.540
b. All actions using this tables became slow. Copying an order uses
table 1,2 en 3, so it's very slow.
Solutions.

a. Change the code > stored procedures.
Problem1: I don't know it yet. So I 'll have to give it to another
person !!
Problem2: Even this solution 'll have limits on size, I suppose!

b. Copy the DB as an archive and delete old data (orders and products)
in the running DB.
Orderdelting can by coded. Productdeleting will always be manual.

thanks,

Filip

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.