List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 18 1999 9:28pm
Subject:Re: HELP WANTED: Tuning to specific specs
View as plain text  
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
Thread
HELP WANTED: Tuning to specific specsScott A. Cole19 Sep
  • Re: HELP WANTED: Tuning to specific specsPaul DuBois19 Sep
    • Re: HELP WANTED: Tuning to specific specsScott A. Cole19 Sep
      • Re: HELP WANTED: Tuning to specific specsPaul DuBois19 Sep
Re: HELP WANTED: Tuning to specific specsmatthew mcglynn19 Sep