ARCHIVING UNDER HEAVY LOAD

2001-03-19 Thread Anatoly Chubais
Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages

Re: ARCHIVING UNDER HEAVY LOAD

2001-03-19 Thread Jeremy D. Zawodny
On Mon, Mar 19, 2001 at 04:06:29PM +0300, Anatoly Chubais wrote: Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that

ARCHIVING UNDER HEAVY LOAD

2001-03-16 Thread áÎÁÔÏÌÉÊ âÏÒÉÓÏ×ÉÞ
Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages

ARCHIVING UNDER HEAVY LOAD

2001-03-16 Thread áÎÁÔÏÌÉÊ âÏÒÉÓÏ×ÉÞ
Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with indexes on it must be kept small?), while other messages

Re: ARCHIVING UNDER HEAVY LOAD

2001-03-16 Thread Fred van Engen
On Fri, Mar 16, 2001 at 12:17:41PM +0300, wrote: Hello! There's a need to design a system (something like online forum) that will be storing huge amount of small messages in database. There must be fast access only to messages for the last 3 days (guess this means that main table with