What im trying now is setting up a different DB with all the view used in the SP's created as tables and the view data imported. I will then run through index analyzer and try the SP's to see what perfomance increase I get, will let you know. Im not bothered about the structurly integrety of this second DB as the data is imported in the first and QA'd before before exported to the second 'live' DB where speed is the main concern.
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]
