|I am using STARTROW and MAXROWS to display one page at a time,
|and calling the same page with different arguments to change
|the page I am displaying... BUT this reexecutes the query each
|time. This query searches through a large database and takes a
|little time. This is a pretty inefficient way to do it (I think).
Make sure you use maxrows on the cfquery tag, to limit the query to your
maxrows cfoutput size.
Also A verity search will probably produce a quicker response then a
standard select statement.
Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]
NOTICE:
This communication is confidential. The copyright in this communication
belongs to Ireland Film & Television Net (IFTN) or a third party.
If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.
Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.
Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
