|
as a follow up ... RE: 'the load on the server seems to be higher than normal.' ...
this is common, especially on databases that gradually grow ... at any rate of speed and size. The more data in the system, the slower it will run ... fairly common, performance tuning is again the best way to resolve this issue .. and sometimes, a query that performed really well with little data will perform horribly with lots of data ... the inverse is also sometimes true where a query that performs well with lots of data, performs poorly with little data (in comparison, heh)
|