Development Blog: Customer Search

Read the thoughts and ideas of the developers and contibuters to Arctic Reservations, an online reservation management tool.

 
by Nathan Perkins

Customer Search

Zach's comment about needing a way to eliminate customers who have had recent activity is a very good point. For this reason, the customer search now has fields for "most recent inquiry" and "most recent reservation". Using these, you can eliminate customers who have had active communication with you from your mailing list.

Implementing these involved expanding the search function in an interesting way. In order to test people's most recent reservations and inquiries, you must actually go through each customer row and look up such data. For this reason, now searches that have eitehr "most recent inquiry" and "most recent reservation" will take longer (14 seconds as opposed to 0.1 seconds for about 7,000 customers). Although this still isn't too long, it is important to be aware of why some searches might take a lot longer.

Eventually, similarly complex fields will be added which extend the running time of searches as well.

Labels: features

December 15, 2005 6:46AM • permalink

Comments

Post a Comment