We've been using one.com as a host and in there everything is all OK and on my personal test server I'm using
has Fedora 14 on it and if I copy everything (webfiles/db) from one.com and "install" that into my server everything
works perfectly. (chaachter wise)
Now in this 1.3.4 version we have one extreme problem at one.com since they have no more then 64M for php that
only shows when there are about 250...280 concurrent users online, both registered and visitors.
This is the error we get: (Debug turned on)
Database reported: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (Errno: 1104).
as I've googled for this it seems to be a memory issue in php and one.com only allows 64M
or that 1.3.4 has some "issues"
The post itself will be done and then this error pops up but all things that should be done afterwards, like increasing the
users post amount etc. won't.
This is forcing us to move from one.com but then we got these Swedish character errors
(but I still think that this error will popup since that place too only has 64M for php.)
so, we got 2 issues here and I don't know what to do?
Can anyone help out?