At 4:25 PM -0500 9/18/99, Scott A. Cole wrote:
>Cool. Thanks for the quick response.
>
>> >We have a high traffic site that is very database intensive (lot's of
>> >connections, >100 tables, <1,000,000 rows per table). Our dB is very
> very
>> >slow when doing complete inserts and updates.
>>
>> I assume that you have indexes on the table? If not, there's your
>> problem.
>
>Yep, whenever possible.
>
>>
>> What do you mean by "complete" inserts and updates?
>
>typo. Just any standard operation (sql) with many people connected.
Are there almost always people reading from the table? Lots of readers
will tend to slow writers down.
--
Paul DuBois, paul@stripped
