[Tool/Web/Other] SQL Queries freezing the server - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [Tool/Web/Other] SQL Queries freezing the server (/showthread.php?tid=169256)

---

SQL Queries freezing the server - cmg4life - 18.08.2010

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

Any fixes?

---

Re: SQL Queries freezing the server - Scenario - 18.08.2010

Wrong section...

---

Re: SQL Queries freezing the server - Cameltoe - 19.08.2010

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

---

Re: SQL Queries freezing the server - Scenario - 19.08.2010

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!

---

Re: SQL Queries freezing the server - Cameltoe - 19.08.2010

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

---

Re: SQL Queries freezing the server - Kyosaur - 19.08.2010

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

---

Re: SQL Queries freezing the server - Kyosaur - 19.08.2010

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.

---