The problem that i am having is the speed in which some code runs. This code is a SQL that does a join on like 5 tables and from the information i then create an array with 10 elements per record in it.
this array is then analaysed through 4 if statments creating a listing of all the data within the array.
Now i have 2 versions of this one in which i used sql code to check some variables and now i changed that to be if statements to increase speed.
The version of Mysql i use at work for testing is 2.23.22 beta.
The Version on the webserver is 3.22.26a.
Now locally the test code with the 4 sql's takes 2.5 secs to run, with the if statements it is less than 1 second. Now when i move these 2 files to the webserver they take between 10-15secs to run. Now some of this time can be acconted for in lag over the internet. But where is the rest of it comming from?
The webserver isa very powerful Server box, but is under high load
06:36PM up 3 days, 14:46, 10 users, load average: 6.29, 5.12, 4.61
that their is an example but it usuall is around 2-3 for load stats.
I have though alot about the issues involved with this, and i am at a loss as 2 why it is so slow on the server. I have been assured that other users arnt having the slow downs that i am having.
Basically are their things that version 3.22.26a of mysql cant handle as well as 3.23.22. Such things as multiple table joins and searchs?
Could this be causeing the extra slow down?
My understanding of how servers work is that they only process X amount of processes per cycle thus maybe taking many secs to process all the if statments and slow down page loads, that use the query.
If anyone can offer me some advice on what may be causing this be greatly apreciated.
Any Tips tricks things to watch out for that may be causing slow downs. Any and all information would be apreciated.
this array is then analaysed through 4 if statments creating a listing of all the data within the array.
Now i have 2 versions of this one in which i used sql code to check some variables and now i changed that to be if statements to increase speed.
The version of Mysql i use at work for testing is 2.23.22 beta.
The Version on the webserver is 3.22.26a.
Now locally the test code with the 4 sql's takes 2.5 secs to run, with the if statements it is less than 1 second. Now when i move these 2 files to the webserver they take between 10-15secs to run. Now some of this time can be acconted for in lag over the internet. But where is the rest of it comming from?
The webserver isa very powerful Server box, but is under high load
06:36PM up 3 days, 14:46, 10 users, load average: 6.29, 5.12, 4.61
that their is an example but it usuall is around 2-3 for load stats.
I have though alot about the issues involved with this, and i am at a loss as 2 why it is so slow on the server. I have been assured that other users arnt having the slow downs that i am having.
Basically are their things that version 3.22.26a of mysql cant handle as well as 3.23.22. Such things as multiple table joins and searchs?
Could this be causeing the extra slow down?
My understanding of how servers work is that they only process X amount of processes per cycle thus maybe taking many secs to process all the if statments and slow down page loads, that use the query.
If anyone can offer me some advice on what may be causing this be greatly apreciated.
Any Tips tricks things to watch out for that may be causing slow downs. Any and all information would be apreciated.