[cmg4life]

Any query freezes the server for about a second or less, depending of it's task.

Any fixes?

[Scenario]

Wrong section...

[Cameltoe]

Get a reliable host .. Sql and samp server should be running at the same place (local)

[Scenario]

Not necessarily. It's recommended to have the same host for MySQL and server hosting, but as long as you don't get a free MySQL server, you should be alright. You can always use one off your web-host, that's what I'll be doing for testing purposes... It's up to you!

[Cameltoe]

If your webhost is based in china, and samp server based in england, OFC this will cause freezing.

[Kyosaur]

Get a host that offers mysql, or switch to a threaded mysql plugin (if you have one, use the threads...).

[Kyosaur]

Quote:

Originally Posted by ****** Or use the SQLite sytem BUILT IN to the server - then you know it's local.

You and your sqlite lol. Can you explain to me why you chose the sqlite over mysql? Only reason i would use it would be due to the speed, but to me its not worth it. Its a pain in the ass to integrate with other things such as websites :\. It also has no options for threading (well i guess you could make a plugin?) and is terrible with BIG loads.