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 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