php Gurus? - Is this happend with anybody
Posted: Wed May 21, 2003 6:25 am
I am trying to execute a mysql queries in a sequence.
Let me explain.
In a file i am having some mysql queries ,some select,insert and update.
When there is no load on the server this script executes very well .
But when the number of users access to the site then this sctipt
does the update and select queries randomly.
Did you got it?
Did anybody faced the same?
is there any solution for this
Let me explain.
In a file i am having some mysql queries ,some select,insert and update.
When there is no load on the server this script executes very well .
But when the number of users access to the site then this sctipt
does the update and select queries randomly.
Code: Select all
e.g when i select balance field from a table
and i want to update it in next statement then it works well for low load on server.
But when load is more then before this update some queries are inserted and the balance is changed
but our select query is having old balance and thus all next calculations are wrong.Did anybody faced the same?
is there any solution for this