[dev] [cvs] commit: genie item.php wishlists.php genie/lib Genie.php base.php genie/po genie.pot sl_SI.po genie/templates/wishlists shared.inc

[duck at obala.net]

Quoting Chuck Hagenbuch <chuck at horde.org>:

> Quoting Duck <duck at obala.net>:
>
>> Having additional info to a separate storage like currently in  
>> Ansel is still
>> a bottleneck. As you must still go into the database twice, create two
>> objects and two DB connections. If is really needed we can separate tables,
>> but data must be picked up in one run. Storing additional data in the main
>> table avoids another (not needed) JOIN.
>
> But isn't this the problem we ran into with the DataTree also? Putting
> everything in the main table can be just as inefficient.

The main difference is that attributes are flatten. So can be indexed,  
as data ar one per row where is this possible. I will digg into this  
issue with Ansel this weekend.

>
> Also, why would you need two database connections?

Looking at my sql query log, one connection is done by DT and the  
other by Ansel MDB2 driver. Even using same db and credentials.

Duck

-------------------------------------------------------------------
Sporočilo poslano in pregeldano proti virsuom z www.DrugaPisarna.si