The new DB with all views imported into actual tables, after running through index analyzer are running slightly faster. The 2 queries that run one after the other are now running at about 280-500ms rather than about 500-1000ms.
Dan -----Original Message----- From: Ben Timby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 18:22 To: ActiveServerPages Subject: RE: Sql Server 2K -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Daniel, to follow up, I have denormalized tables in order to gain perfomance before. If your normalized tables are too slow for JOIN operations, then you really don't have much of a choice. It is acceptable to break the rules of normalization if you understand the consequences, and the benefits are great. Ben Timby Webexcellence PH: 317.423.3548 x23 TF: 800.808.6332 x23 FX: 317.423.8735 [EMAIL PROTECTED] www.webexc.com - -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:09 AM To: ActiveServerPages Subject: RE: Sql Server 2K Do you rely on the index Tuning Wizard from query analyzer to index your table? Dan - -----Original Message----- From: Showbear [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 15:58 To: ActiveServerPages Subject: RE: Sql Server 2K Dan, one of our apps has a SQL Server 2000 database in which some tables contain over 25 million rows. Properly indexed, performance is - to be scientific - blink-of-an-eye fast. HTH - -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:09 AM To: ActiveServerPages Subject: OT: Sql Server 2K 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.unsub%% - --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ 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 _____________________________________________________________________ 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.unsub%% -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 iQA/AwUBPUgcZ/nby1cCm2Q8EQI+UwCg5T1ZS4W708ipmwrYYwT6yX2Wye4AnRKh hZv8ZueMf1MAgsMjtG9OrgkQ =fRsG -----END PGP SIGNATURE----- --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ 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 _____________________________________________________________________ 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]
