[ic] flypage optimization

Stefan Hornburg interchange-users@icdevgroup.org
Tue Jan 28 15:12:00 2003


On Tue, 28 Jan 2003 14:14:16 -0500
"Jeff Dafoe" <jeff@badtz-maru.com> wrote:

> Hello,
> 
>     Am I correct in thinking that item-description and item-field whatever
> issue one query each?  If so, am I correct in thinking that on the flypage I
> can do a single query using data session arg and get out all of the fields
> that I need at once and then just use prefix-param to display them on the
> page?  Some of my items have dozens of thumbnails and associated descriptive
> text and I don't like to work old postgresql too hard.

I suppose that will allow you to decrease the number of queries. To be sure,
watch the postgresql logs closely.

Bye
	Racke