Slow database because of size

[dragonkeeper1973]

I have 12000+ items that has caused me to have a large database and resultes in it being slow.

 

Is the a way to fix this issue ( example...dual database), or other, while maintaining my inventory while still being able to add more to my inventory?

 

Thank in advance for any help I can get with this.

 

 

Dallas aka dragonkeeper1973

[crash3903]

I have 12000+ items that has caused me to have a large database and resultes in it being slow.

 

Is the a way to fix this issue ( example...dual database), or other, while maintaining my inventory while still being able to add more to my inventory?

 

Thank in advance for any help I can get with this.

Dallas aka dragonkeeper1973

 

by removing the overhead for the tables this sometimes helps with performance

[dragonkeeper1973]

by removing the overhead for the tables this sometimes helps with performance

by removing the overhead, do you mean optimizing the tables?

[♥Monika in Germany]

start with indexing the columns used frequently for your queries. Make sure the categories.php box has the function to count products commented out ... both will help fast.