Re: Performance of large queries

[prev] [thread] [next] [Date index for 2004/07/15]

From: Perrin Harkins
Subject: Re: Performance of large queries
Date: 17:13 on 15 Jul 2004
On Thu, 2004-07-15 at 03:00, cdbi-talk@xxxxxxxxx.xx wrote:
> But in this case I don't need objects to be returned as I don't want
> to modify them; I simply want to retrieve the data. Is there a way to
> tell Class::DBI to return either the sth-object or is there an other
> way to improve the performance of the search?

There is considerable overhead in creating all the objects, so if you
don't need objects and are worried about performance you should look at
doing direct SQL queries.  See the "Ima::DBI Queries" section of the
docs.

- Perrin

Performance of large queries
cdbi-talk 07:00 on 15 Jul 2004

Re: Performance of large queries
colm-cdbi 09:27 on 15 Jul 2004

Re: Performance of large queries
Tony Bowden 09:35 on 15 Jul 2004

Re: Performance of large queries
colm-cdbi 09:58 on 15 Jul 2004

Re: Performance of large queries
Tony Bowden 10:04 on 15 Jul 2004

Re: Performance of large queries
Perrin Harkins 17:13 on 15 Jul 2004

Re: Performance of large queries
cdbi-talk 19:22 on 15 Jul 2004

Re: Performance of large queries
colm-cdbi 21:05 on 15 Jul 2004

Re: Performance of large queries
Tony Bowden 23:05 on 15 Jul 2004

Generated at 11:34 on 01 Dec 2004 by mariachi v0.52