My computer: Windows Vista Basic, Intel Core 2 Duo 2.8GHZ, 4GB memory. Task manager shows 1.61GB memory currently being used.
Currently I can insert anywhere from 10k to 15k rows (<1kb/row) per second. If i had an actual server like this https://www.servint.net/order.php?pkg=27 with 8gb of ram and quad cores of 2.5GHz would I be able to double my amount of inserts or triple them maybe? If I was using this as purely a mysql db server would i set it up any differently than I would a regular server?
Basically I want to know what factors enable you to increase the amount of inserts you can do per second.