Re: DataObject and Slow Queries
| From: | Justin Patrin | Date: | Tue, 07 Dec 2004 07:12:57 +0000 |
| Subject: | Re: DataObject and Slow Queries | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16078@lists.php.net to get a copy of this message | ||
On Tue, 07 Dec 2004 05:11:45 -0200, Jacques <iacques@yahoo.com.br> wrote:
> Is DataObject indicate to make queries? Why it is slow?
>
> The performance without relationships (LOOPS) is acceptable (2,5 times
> slower than with native access), however when making relationships with
> getLinks or getLink (LOOPS) the performance falls very (approximately 8x
> slower).
Depends on how you do it natively. If you're doing it with JOINs vs.
using getLink or getLinks, yeah, it's going to be slower. That's 1
query per linked field per record. You can use the addjoin/etc.
methods in DO to make a JOIN query which should be faster.
>
> Somebody also noticed this?
>
> Jacques
>
--
Justin Patrin