Adding PKs should be enough. The problem in larger DB systems is the use of GUUID for a PK (when I mean large, I mean multi GB DB).
Do not over index - this can be a performance killer. As long as you have a clustered index on PK you should be fine! "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: [email protected] <[email protected]> To: [email protected] <[email protected]> Sent: Sat May 13 02:52:59 2006 Subject: [farcry-dev] Re: indexing/optimising the database The first thing to do is to go through the tables and create primary keys and the default indexes on those PKs. That should make a dramatic difference in performance. I'm doing that on my database right now. If i have the time i'll try and write a script that'll do this for the whole farcry db. At least for MS SQL server, cause that's what i'm using. Steve -- Sent from the FarCry - Dev forum at Nabble.com. This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev -~----------~----~----~----~------~----~------~--~---
