As AJ said, you probably need indexes. Objectid mostly, but the default sort field (datetimemodified?) may need something too.
On Thu, Sep 9, 2010 at 4:50 PM, smika <[email protected]> wrote: > Thanks a lot! > But do i need to modify webtop and core? I mean on a frontend i dont > have any problems, thanks to your decorators related article. > My problem is that on a admin side i have terribly slow performance, > while trying to administer Articles table. > > > On Sep 9, 10:57 am, Blair McKenzie <[email protected]> wrote: > > This would also be a good time to review your webskin caching strategy. > Some > > good resources are > > -https://farcry.jira.com/wiki/display/FCDEV50/UNIT+08+-+Object+Broker,. > .. > > for 5, but applies to 6 too) > > -http://farcry.posterous.com/quick-summary-of-farcry-view-decorators > > > > Blair > > > > On Thu, Sep 9, 2010 at 3:45 PM, AJ Mercer <[email protected]> wrote: > > > this was written awhile ago > > > but it will give you some tibps for database indexing > > > > >https://farcry.jira.com/wiki/display/FCDEV30/Database+Indexing+Strate. > .. > > > > > < > https://farcry.jira.com/wiki/display/FCDEV30/Database+Indexing+Strate...> > > > > > 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]> > <farcry-dev%[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]<farcry-dev%[email protected]> > <farcry-dev%[email protected]<farcry-dev%[email protected]> > > > > > For more options:http://groups.google.com/group/farcry-dev > > > -------------------------------- > > > Follow us on Twitter:http://twitter.com/farcry > > -- > 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 > -- 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
