Hi all, I have a fairly complex DB structure from which I query and return XML results. The structure is working fine, but the query can be a bit slow as I have to query several differnt tables (Well comparatively slow, running about 700-2000 ms). I have created a lookup table which is a single table with all the variables in it, the question is, this table is currently at 250,000 rows. I have re-wrote the query to use this yet, but is it better to do it this way rather than link across the 5 or so tables? The row count could easily get close to the 1million mark in the future.
Dan _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
