2009年9月30日星期三

Re: [fw-db] Zend_Db::fetchAll() unacceptably slow

On Wed, Sep 30, 2009 at 2:37 PM, Саша Стаменковић <umpirsky@gmail.com> wrote:
> Looks like slow db
> connection http://www.screencast.com/users/umpirsky/folders/Jing/media/953fb733-e2e8-4456-a9cd-0e4570722110
> What can I try? Maybe other server :P

Is the database server not on the same server? If it's external (on
another server), there are multiple things:

a) Replace DNS host with an IP address, saves the lookup (or fix the DNS)
b) If it's not DNS, let your ISP review the issue.
c) Better server and/or connection between those.

You could also apply the cache to Zend_Db_Table to save the meta data
between requests. And maybe cache the response from the database
entirely to avoid the SQL calls.

Till

没有评论: