search

voodoodyne / subetha

SubEtha Mail is a J2EE-based mailing list manager
Other
13 stars 6 forks source link

Review table indexes #3

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Review all entities and make sure they have the correct indices.

Original issue reported on code.google.com by lhori...@gmail.com on 4 Jun 2009 at 9:54

GoogleCodeExporter commented 9 years ago

Original comment by lhori...@gmail.com on 4 Jun 2009 at 10:06

GoogleCodeExporter commented 9 years ago 
As a practical matter...  has anyone noticed any performance problems with a 
large number of users and/or a large amount of emails??  For the last year, 
Subetha has been rock solid for OpenSCG, buty, our volume is light so far.

Original comment by lussm...@gmail.com on 30 Dec 2010 at 4:15

GoogleCodeExporter commented 9 years ago 
We haven't noticed any performance issues on the SE instance we run, but it 
doesn't get massive traffic.  It does have a fairly large corpus though.

I think the indexes are pretty spot-on.  However, it's hard to precisely 
control them - Hibernate does the creation and it does different things on 
different databases.  It's even possible that the old version of Hibernate we 
used to create my SE database will create different indexes than the current 
(updated) version of Hibernate.

Unfortunately there are a lot of variables that are not practical for us to 
test.  All I can say is if you get a lot of traffic and find that performance 
degrades, it's pretty easy to check the queries on most databases and make sure 
they are following efficient indexes.

Original comment by lhori...@gmail.com on 11 Jan 2011 at 2:59

GoogleCodeExporter commented 9 years ago 
unless there is a specific problem....

Original comment by jasonpye...@gmail.com on 12 Apr 2014 at 2:21