Advice needed for high volume of inserts

2004-01-20 Thread STE-MARIE, ERIC
Hello, This is my first message on this list. So I take the occasion to salute every one of you. I'm looking to implement a database server wich will mostly insert data. The data structure is not complexe. The data will be insterted in 1 table at burst rates of 13000 insert/seconds and

Re: Advice needed for high volume of inserts

2004-01-20 Thread Peter J Milanese
-Forwarded by Peter J Milanese/MHT/Nypl on 01/20/2004 02:36PM - To: STE-MARIE, ERIC [EMAIL PROTECTED] From: Peter J Milanese/MHT/Nypl Date: 01/20/2004 02:31PM cc: [EMAIL PROTECTED] Subject: Re: Advice needed for high volume of inserts It'll work. I do slight less on the way

Re: Advice needed for high volume of inserts

2004-01-20 Thread STE-MARIE, ERIC
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On January 20, 2004 02:31 pm, Peter J Milanese wrote: It'll work.   I do slight less on the way of inserts. What I do is dynamically generate the tables within my entry code, and merge tables based on the query. Good for large log parsers. Be

Re: Advice needed for high volume of inserts

2004-01-20 Thread Peter J Milanese
PROTECTED] From: STE-MARIE, ERIC [EMAIL PROTECTED] Date: 01/20/2004 02:41PM cc: [EMAIL PROTECTED] Subject: Re: Advice needed for high volume of inserts -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On January 20, 2004 02:31 pm, Peter J Milanese wrote: It'll work. I do slight less on the way