24.01.2014, 18:01
Quote:
I agree something must be wrong with your mysql server's configuration or something.
When you tried using threaded queries, did your server freeze execution the whole time it was dumping data? EDIT: Is your MySQL server running locally or on a remote server? |
Threaded queries didn't freeze OnFilterScriptInit, non-threaded did.
Just ran another test to do the same when the data was already in place.
The ID field is primary key, so the queries will be sent to MySQL, but the data won't be overridden as the data already exists.
This only took 71 milliseconds.
Perhaps MySQL is increasing filesize of the database everytime when a new record is being added, this might be what takes so long.
I'm using BlueG's plugin R34.
For the server, I'm using MySQL Community Server 5.6.15.