Many queries
#2

Depends on the type of query (select, insert, update), the query itself, the database engine (InnoDB or MyISAM) and the hardware that runs it. A run of 50 queries per second seems pretty standard though (20 millisecond average). The average single select query takes between 5 and 15 milliseconds to execute and then there's the overhead from Pawn.

For batch inserts or updates use transactions so that the database doesn't automatically commit after each statement.
Reply


Messages In This Thread
Many queries - by Bussyman - 08.04.2017, 06:57
Re: Many queries - by Vince - 08.04.2017, 08:26

Forum Jump:


Users browsing this thread: 2 Guest(s)