Quote:
Originally Posted by Ferus
was the MySQL local on the VPS, or in a separate central serverfarm, as some do?
|
I assume it was on the local machine, but I don't know for sure. I connected to mySQL through localhost, but they could have some creative stuff going on redirecting it to another box. Queries were pretty quick even on 100 million records and 6 Gigabyte DB. About 1 min 30 seconds searching a non-indexed table. Now I have it down to milliseconds all indexed in 32 GB ram on a dedicated box at ovh... love VPS machines for getting things up and going though, quick and easy to re-install the OS many times if you mess it up.