| Problem is, company's will be added in constantly. About 10 rows are being added to the adata table each second (every second of the day.. everyday etc)
Adata table is constantly getting bigger and bigger. Forever. New data being constantly added. The php front end is analyzing this data. Alot of it is repeating..
Sound bad?
I looked at the computer while ruinning a query.. 0% cpu use.. all hard disk swapping. |