Ever Wanted to Own and Operate a Fully Featured
Dynamic DNS Service?
Now You Can With MintDNS 2009 Enterprise - - Our
Award Winning Dynamic DNS (DDNS) Server Suite!!!
It's never been easier to run your own DDNS service.
Looking for free Dynamic DNS (DDNS) services? Please use our free DDNS
service at
http://www.dynddns.us
MintDNS Knowledge Base
Go Back
Please note that the default table indexes are fine in most circumstances,
and were designed with minimal Memory requirements in mind.
If you make the following changes your Databases performance will be increased substantially, but Memory consumption on your system will also increase substantially. A minimal 3 GB of Ram is recommended when using the improved SQL indexes. To apply these changes run the following command from SQL Management Studio.
T-SQL Code:
USE [mintdata]
GO /****** Object: Index [PK_Records] Script Date: 05/10/2009 15:32:30 ******/ IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Records]') AND name = N'PK_Records') ALTER TABLE [dbo].[Records] DROP CONSTRAINT [PK_Records] IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[UpdateLogs]') AND name = N'uid') DROP INDEX [uid] ON [dbo].[UpdateLogs] WITH ( ONLINE = OFF ) IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND name = N'PK_Users') ALTER TABLE [dbo].[Users] DROP CONSTRAINT [PK_Users] CREATE UNIQUE CLUSTERED INDEX [ID] ON [dbo].[Records] ( [ID] ASC, [UserID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE CLUSTERED INDEX [uid] ON [dbo].[UpdateLogs] ( [Uid] ASC, [DD] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [URL] ON [dbo].[UpdateLogs] ( [URL] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE UNIQUE CLUSTERED INDEX [ID] ON [dbo].[Users] ( [ID] ASC, [UserID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
Go Back