[ic] select * from products

[Stefan Hornburg]

On Mon, 19 May 2003 01:16:12 -0700 (PDT)
"Christian Brink" <cbrink@schmidy.com> wrote:

> The search/scan's 'select * from products' is killing my performance. It
> takes 17 secs for PostgreSQL to return the 38k sku's.
> 
> What is my best option for dealing with this:
> 1. rewrite search to use WHERE clauses? if so, can someone point out where
> the 'search' sub is?

You either use op=eq or lf/ls in your searches.

> 2. rewrite the results page to use [query]?

That is a possibility as well.

Ciao
	Racke



-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team