pfilias Posted February 29, 2012 Share Posted February 29, 2012 We've been running an osC store for a customer whose order table has grown to nearly 20,000 records. The fulfillment house they use has a federated database they use in conjunction with the osC data. While working against the osC database, they are seeing some extremely poor performance while querying it. How can I go about archiving the orders, and, what would I prune? Is there an addon that would solve this for them? Link to comment Share on other sites More sharing options...
pfilias Posted March 2, 2012 Author Share Posted March 2, 2012 Nobody ever had to deal with archiving orders to clean up the database? My order_products table has about 26000 records. I don't think that's very large, but a 3rd party seems to think it's causing his federated database call to time out. Please help. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.