Thanks for all the useful information. I'm going to ensure the
relevant fields are indexed and our db is optimised.
On 4 Sep 2010, at 16:10, Arthur Fuller wrote:
100% agreed.
Arthur
The other exception is also where financial data is being stored. If
you
have, say, a database containi
I believe that will not be logged unless you have enabled log_warnings. Too
many
connections would normally mean that the number is going beyond the configured
limit and denying new sessions is an expected behavior and should not be an
error really.
Regards,
Nitin
_
Hi,
Have you recently upgraded your MySQL installation? 1064 in earlier days used
to
mean use of reserved word. Few clients have reported this error in last couple
of months after they upgraded from 5.1.41 to higher versions. As of now, I
don't
have a solution other than changing the name (of
100% agreed.
Arthur
The other exception is also where financial data is being stored. If you
> have, say, a database containing sales order records, then as well as
> storing the individual values of each item in each order, you also need to
> store the total value of the order, the total price c
