this was written awhile ago but it will give you some tibps for database indexing
https://farcry.jira.com/wiki/display/FCDEV30/Database+Indexing+Strategies+for+FarCry <https://farcry.jira.com/wiki/display/FCDEV30/Database+Indexing+Strategies+for+FarCry> On 9 September 2010 13:36, smika <[email protected]> wrote: > Dear friends, > > we are finalizing a farcry-driven website for local news agency. It > was fine when it was running with test data, but now we've imported > their old articles and our ctArticle table is 26.000 rows. It leads to > very slow startup, and logging took a 5 mins. When it comes to > browsing articles under webtop it perform toooo slow. > > We're running CF9/MySQL 5 combination. > > Any tips to optimize the performance? > > Thanks, > > Mika > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: > [email protected]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry -- *AJ Mercer* <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org community="Open" /> <http://webonix.org> http://twitter.com/webonix -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
