'Twas brillig, and Lukasz Szybalski at 26/02/10 16:14 did gyre and gimble: > > > On Feb 25, 7:07 pm, Chris Mulligan <[email protected]> wrote: >> What in the world are you doing that's generated 6000 tickets a day? >> How can you possibly use the system at that rate? > > 600 not 6000. > > faxes mostly. We have ~25 people processing these tasks. > > Would anybody familiar with trac database structure confirm or deny > that switching the ticket_custom from text to varchar will allow for > substantial performance increase?
I'm sure you can change it to varchar but AFAIK this is limited to 255 characters so will not work for custom fields where the data is larger than that. You could perhaps experiment with adding a full text index to the field tho'. Although this will require modification of the code that actually does the searching to use the match() ... against syntax I believe which makes it somewhat annoying. http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html Col -- Colin Guthrie gmane(at)colin.guthr.ie http://colin.guthr.ie/ Day Job: Tribalogic Limited [http://www.tribalogic.net/] Open Source: Mandriva Linux Contributor [http://www.mandriva.com/] PulseAudio Hacker [http://www.pulseaudio.org/] Trac Hacker [http://trac.edgewall.org/] -- You received this message because you are subscribed to the Google Groups "Trac Development" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en.
