High-speed data writing - Printable Version

High-speed data writing - 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: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: High-speed data writing (/showthread.php?tid=428454)

High-speed data writing - MP_Spec - 05.04.2013

Hi.

I have a huge database MySQL (players, gangs, houses, vip accounts, parkour, races, priv. cars, stats and much more).

During the day, there are over 100 000 queries.
They are often delays in eg retrieving from the database the next checkpoint position in the race.

I'm looking for something that performs faster and more smoothly than MySQL queries. There is such a thing? It is important to also be able to use it from within PHP.

Sorry for my bad english.

Re: High-speed data writing - Bakr - 05.04.2013

You aren't using it correctly. Look up tutorials for MySQL optimization, there are thousands.

You also shouldn't be querying everything. For example, you could store temporary race checkpoints in an array while it is being used.

Re: High-speed data writing - iJumbo - 05.04.2013

You can learn how to optimize database and query from http://www.techrepublic.com/article/...ueries/6137168

Quote:

Originally Posted by Bakr

You aren't using it correctly. Look up tutorials for MySQL optimization, there are thousands.

You also shouldn't be querying everything. For example, you could store temporary race checkpoints in an array while it is being used.

but if he want show in php the current checkpoint he have to do that

Re: High-speed data writing - Konstantinos - 05.04.2013

Quote:

Originally Posted by MP_Spec

They are often delays in eg retrieving from the database the next checkpoint position in the race.

As Bakr said, it's no need to get data from MySQL all the time. That's why there are temporary variables we can store on them.

Since you've got so many stuff, it's better using MySQL for a better speed. Using threaded queries and cache will run them quickly.

Re: High-speed data writing - MP_Spec - 05.04.2013

MySQL queries are optimized, the server also.
InnoDB disabled.
Queries to the table of players is by a unique ID, not a nickname, etc.

The only thing I can not set good the cache size, operational, etc.

I wanted to find a quicker alternative. Everything works on one machine, so downloading from the PHP would not be a problem even for ordinary files.