Re: Shadow.pm v. 1.23 slower than 1.22

On Fri, 11 Apr 2003 11:19:32 -0700
Kirill Sapelkin <[email protected]> wrote:

> Hello,
> 
> The Shadow.pm 1.23 works fine, allows us to select different columns
> in products and specs.txt, except is slower than v 1.22.
> 
> On my machine, http://localhost/cgi-bin/znanie:
> 
> Click on Home button
> 
> with ru_RU locale      with en_US locale            with 1.22 ru_RU
> 7 secs                    4 sec                            1 sec
> 
> Search on sku
> with ru_RU locale      with en_US locale            with 1.22 ru_RU
> 
> 16 sec                    7 sec                            2 sec
> 
> We have a mysql products table with about 5000 items and 4 specs for
> each one in the specs.txt.
> 
> Is this supposed to be this way? Would it be faster if we used text
> only database?

The shadow database adds another level of abstraction, so an overhead
is to be expected. Furthermore, optimization of Shadow.pm isn't planned
for Interchange 5.0, but certainly possible.

Can you please repeat your database settings so I can check for 
possible problems.

Bye
	Racke