High s-side CPU usage

[Sylvek]

Hi!

I scripted function that makes loop which gets result from MySQL and put this to gridlist. It's like refresh button which loads items for sale. Problem is that one use of this button take about 0.25% server CPU usage. Bigger problem is that I can spam this button and it takes about 10% of server cpu usage. Don't know if it's normal or too high. Could you help me and say how to decrease this and it's normal?

Edited November 27, 2017 by Sylvek

[IIYAMA]

Write one query to get the result, not 100000.

[Sylvek]

I am doing like you say.

local result = exports(dbquerry) etc. 

And doing loop like this

For i,v in pairs(result) do

 

[IIYAMA]

 

 

Show the query you are using.

 

Solutions:

• You might want to use a callback, because the lua code will pause when you execute the query(if no call back). (which can cause a lot of lagg if the requested data size is very large)
• Save the data you collected inside of a table(as buffer). Use tickcount to decide if you re-call the mysql database or use the buffer. (which can improved your performance with 100 t/m 1000%) So if a guy is spamming/pushing the button a lot of time, your cpu usage will stay normal.
• Improve your query and set a: LIMIT 1000. Which will make sure that you do not overheat your database. You might not get all the results you need, but you can also request more later, see this example: https://stackoverflow.com/questions/5767479/mysql-limit-range

 

 

Edited November 27, 2017 by IIYAMA

[Sylvek]

I am not at computer at this moment but it's like that:

local result = exports(DB,dbQuerry(select * from table where owner = ?,owner)

[IIYAMA]

Is there always 1 data per owner? Or can there be more data per owner?

 

 

[Sylvek]

There can be more data.

[IIYAMA]

Your query looks fine.

I hope the solutions will help you with solving your problem.