Unfortunately, the database vendor has been unreachable during the process of trying to figure out how the constructed their database, why they did it that way, and why their schema for the tables doesn't match the delimited data files I had to import.
There are about 8,000 properties currently. No, none of the tables are alike. They do share some fields, but there is a lot different about each one. I'm using MySQL 5. I've got proper indexing on the tables now (as far as I know) based on other's advice, which has greatly sped up my queries. It looks as if I'm going to have to run through queries on each property table to see if I can find a match to the property id.... - query the acreage table, if no match, - query the lot table, if no match, - query the rental table, etc. until a match is found. Really can't see another way of doing it with the properties spread out between tables. Is there some conditional code I can use in a single query that allows me to search for a property id in multiple tables? Thanks for the feedback. Rick > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 24, 2008 12:06 AM > To: CF-Talk > Subject: RE: Need some advice on speeding up query... > > > How do I use a url variable to link to a property details > > page when the properties are in 8 different tables? The > > issue really isn't the variable, since I can use the aliased > > variable "property_id" (once I add it to the query). > > > > I know I could use > > property_details.cfm?property_id=<cfoutput>#get_properties.pro > > perty_id#</cfoutput>, > > however, on the details page, I would need to search all > > eight property tables for the correct property id. > > > > Is this the method I'm stuck with because all the properties > > aren't in a single table? > > Pass the aliased variable "property_id" and search all 8 > > tables for it? > > > > Perhaps I should just put them all into one big property > > table instead of keeping them separate as the data vender has > > them... > > Are all these tables identically constructed? That's what it looks like from > the query. If so, I can't imagine why the vendor would tell you to do that. > Did the vendor explain this to you? What database server are you using? How > many records are we talking about? Are the tables properly indexed? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
