Re: [NOVICE] [PERFORM] Extreme high load averages

2003-07-10 Thread Martin Foster
Shridhar Daithankar wrote: I have an idea. How about creating a table for each day. Use it for a while and rename it. Since you can rename a table in transaction, it should not be a problem. You can use inheritance if you want to query all of them. Using indexes and foregin keys on inherited

Re: [NOVICE] [PERFORM] Extreme high load averages

2003-07-10 Thread Shridhar Daithankar
On 10 Jul 2003 at 0:43, Martin Foster wrote: > As for creating a new table, that in itself is a nice idea. But it > would cause issues for people currently in the realm. Their posts > would essentially dissapear from site and cause more confusion then its > worth. No they won't. Say you hav