24.09.2009, 15:31
Thanks for the tips, using transactions helps lots. ~100k INSERTs in 7 seconds, 4 of them for processing the file, 3 for the INSERTs which isn't too bad.
SELECT statements don't seem to be that slow, using "LIMIT 1" doesn't seem to have any effect on the speed. Using SELECT to get a country from ~100k entries takes about 200 ms if nothing is found, which I'm guessing is the worst case since some only take 1ms.
No idea if these numbers are normal or samp being slow, it's almost usable but still not as good as using file operations (the worst case for getting a country is 170ms).
SELECT statements don't seem to be that slow, using "LIMIT 1" doesn't seem to have any effect on the speed. Using SELECT to get a country from ~100k entries takes about 200 ms if nothing is found, which I'm guessing is the worst case since some only take 1ms.
No idea if these numbers are normal or samp being slow, it's almost usable but still not as good as using file operations (the worst case for getting a country is 170ms).