List:General Discussion« Previous MessageNext Message »
From:Ronan Lucio Date:November 23 2005 1:22pm
Subject:Re: Tips for better performance
View as plain text  
> that depends because SugarCRM doesn't delete anything from DB just marks 
> item as deleted using this field.

Do you have an index for deleted column?
It should help.

>> Can you apply any more filter in the users table (like date)?
>> You are requesting all rows.
>
> no, because purpose of this query is to list all contacts, and using LIMIT 
> contacts are then paginated on web site.

Pay attention that a "ORDER BY name" would be executed in
all rows, regardless the LIMIT clause.

>> How many rows do you have in the users table?
>
> We are not sure how many user will be in our DB, but my asumption is that 
> there should not be more than 40 - 50, but don't take my word on it...

Hmmm, so you should do better job in the accounts table.
If this query is used frequently, perhaps filtering by only one user should 
help.

> Will it be enough to use only my-huge.cnf file or we can do some more 
> tweaks?

I guess so.
The bellow documentation has helped me a lot, although it´s for 3.23 
version:

http://www.tnt.uni-hannover.de/print/plain/soft/database/MySQL/Docs/manual_Performance.html

Ronan 


Thread
Tips for better performanceMarko Knezevic22 Nov
  • Re: Tips for better performanceDuncan Hill22 Nov
  • Re: Tips for better performanceScott Haneda22 Nov
  • Re: Tips for better performanceMarko Knezevic22 Nov
    • Re: Tips for better performanceDuncan Hill22 Nov
  • Re: Tips for better performanceRonan Lucio22 Nov
  • Re: Tips for better performanceMartijn Tonies22 Nov
  • Re: Tips for better performanceRonan Lucio22 Nov
  • Re: Tips for better performanceMartijn Tonies22 Nov
  • Re: Tips for better performanceMarko Knezevic22 Nov
  • Re: Tips for better performanceMarko Knezevic22 Nov
  • Re: Tips for better performanceDan Baker22 Nov
  • Re: Tips for better performanceRonan Lucio23 Nov
  • Re: Tips for better performanceMarko Knezevic23 Nov
  • Re: Tips for better performanceMarko Knezevic23 Nov
  • Re: Tips for better performanceRonan Lucio23 Nov