Hi ,
I’m using this free script Affilistore with little modification.
My database become too big more 2 GB with more 3,500,000 it’s on Mysql 5.0.32-Debian_7etch12-log
One page load more 10 seconds, see example of long queries in attach file.
I think they are bad Index on table, and bad SELECT in php script…
What i need :
* Optimizing the database of affilistore with my data
make the good choice of Index or maybe move to innodb system i don’t know.
* Re-code the php script to…
