Re: No way to instantiate two related CDBI classes at once, is there?

[prev] [thread] [next] [Date index for 2004/08/09]

Tony Bowden wrote:
> On Mon, Aug 09, 2004 at 11:22:47AM +0100, Ian McDonald-ONLINE wrote:
> 
>>I'm trying to reduce the number of SQL calls.
> 
> 
> Why? (Serious question)
> 
> Tony
> 

reason is probably same as in my idea few days before ... reduce load.

assume:
  - select from tablex by primary key = 1 ms
  - select from tabley by search = 10 ms
  - select from tabley, tablex by search with join = say 20 ms (in my
tables with postgresql its around 11 ms)

now ... select from tabley has 1000 row and we need select from tablex
for each one ... 10 + 1000 * 1 = 1010 ms

and imagine about large databases with few milion rows

by
barney