Re: [GENERAL] Question on inserting and querying at the same time.

2006-11-08 Thread Erik Jones
Richard Huxton wrote: Wei Weng wrote: I have a database table that has about 90k entries, they are all straightfoward text, and there is only one ID field that I use as primary key for this table. I have two threads working on this table. One of them inserting new content constantly, (about eve

Re: [GENERAL] Question on inserting and querying at the same time.

2006-11-08 Thread Richard Huxton
Wei Weng wrote: I have a database table that has about 90k entries, they are all straightfoward text, and there is only one ID field that I use as primary key for this table. I have two threads working on this table. One of them inserting new content constantly, (about every second) another one

[GENERAL] Question on inserting and querying at the same time.

2006-11-07 Thread Wei Weng
I have a database table that has about 90k entries, they are all straightfoward text, and there is only one ID field that I use as primary key for this table. I have two threads working on this table. One of them inserting new content constantly, (about every second) another one idles and only wak