Re: Table optimization ideas needed
| From: | Shelley | Date: | Fri, 28 Mar 2008 01:41:36 +0000 |
| Subject: | Re: Table optimization ideas needed | ||
| References: | 1 2 3 4 5 6 7 8 9 10 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44839@lists.php.net to get a copy of this message | ||
On Thu, Mar 27, 2008 at 1:55 PM, Chris <dmagick@gmail.com> wrote:
> Good idea. But I wonder whether calling the trigger each insert will loose
> > any performance.
> >
>
> It's going to affect things slightly but whether it'll be noticable only
> you can answer by testing.
>
> Another option I sometimes see is set up a replicated slave and run your
> reports off that instead of the live system, then:
>
> 1) it won't bog the live db down
> 2) it doesn't really matter how many queries you run
> 3) it doesn't really matter how long they take to run
>
Hmmmmm... This makes sense. :)
I indeed have several slaves running.
Great. Thank you.
Thank you for all your help.
>
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
--
Regards,
Shelley