[ic] Complex search using [query]

[Kyle Cook]

I also have done this. A couple of notes:

Be sure to escape any 'BAD' characters from any form
fields used in the query (security)

Also if you plan on routinely returning a large amount
of data and/or records, the IC caching mechanism can
produce very large files:

example of a search for the letter e in a search that returns
3,000 items (apx 12 fields ea) with this set up can
easily reach over 1M file size.

Only real way around it is to do your own paging to add
a LIMIT clause to the sql  (you lose caching, but limit
large file writes/reads to the cache dir, also some sql
will perform faster with a LIMIT clause

My $0.02  :-)

Kyle

At 11:27 AM 7/20/01, you wrote:
>Hello,
>         I just got done doing this myself.
>
>1) correct
>2) correct
>3) don't have to worry about it.  the more list cycles through the 
>results, and doesn't re-query the db.
>
>3a) remember the more-list goes inside the query tags
>
>
>At 10:22 AM 7/20/01 -0700, you wrote:
>>I've found out how to improve search speeds via this list using [query].
>>But I would like more detail on implementation.
>>
>>If I try to implement this using the construct demo, I would have to
>>change the form that accepts the keyword search to simply pass the data
>>on. I would then have to change the results.html page to include the
>>[query]. Is that correct?
>>
>>If I set it up to do the "more" feature, how do I prevent the [query]
>>from being executed on subsequent pages when the user clicks "next"?
>>
>>Peter
>>
>>
>>_______________________________________________
>>Interchange-users mailing list
>>Interchange-users@lists.akopia.com
>>http://lists.akopia.com/mailman/listinfo/interchange-users
>
>Brian Kosick
>Web Programmer
>New Age Consulting Service, Inc.
>216-619-2000
>briank@nacs.net
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users