[MP_Spec]

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.

[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.

[iJumbo]

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

[Konstantinos]

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.

[MP_Spec]

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.