Code Forums - View Single Post

sde · 07-12-2004, 11:26 AM

I'm building this web app which will be used by 25 people max at a time.

I have a very detailed 'advanced customer search'. I want it to work like when you search for flights on orbitz, expedia, or most other big sites like that.

- execute the search
- view an animated gif that says 'searching'
- change the page to display the results.

since there are about a million records, the ability to use 'like' in the query, and possible joins happening depending on the search criteria, this may take some time.

the only way i can think to do this is by saving the result set to a session variable.

you think that is how the airline sites are doing it? my only concern would be hogging server resources, but the advanced search wouldn't really even get used that much.

any thoughts on this?

07-12-2004, 11:26 AM	#1 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,505	Session storage on an intranet app. I'm building this web app which will be used by 25 people max at a time. I have a very detailed 'advanced customer search'. I want it to work like when you search for flights on orbitz, expedia, or most other big sites like that. - execute the search - view an animated gif that says 'searching' - change the page to display the results. since there are about a million records, the ability to use 'like' in the query, and possible joins happening depending on the search criteria, this may take some time. the only way i can think to do this is by saving the result set to a session variable. you think that is how the airline sites are doing it? my only concern would be hogging server resources, but the advanced search wouldn't really even get used that much. any thoughts on this? __________________ Mike