Generally Question [ASP]

Prev: managing multiple virtual folders of cloned websites
Next: ASP Learning

From: Bam on 13 Apr 2008 10:45

Hey gang.

Question here:

If someone registering for the site, enters their GUID. Now a check is made
on that GUID across a DB Table to see if the GUID is present. There are
approx 57,000 GUIDS in said table. It is msSQL DB on windows server 2000
server, how long would that check take?

I know there are several variables that come into play here, but I am
looking for a ball park figure on how long it would and should take.

Any ideas??

Thanks in advance

Bam

From: Bob Barrows [MVP] on 13 Apr 2008 11:17

From: Bob Barrows [MVP] on 13 Apr 2008 11:47

Bam wrote:
> Hey gang.
>
> Question here:
>
> If someone registering for the site, enters their GUID. Now a check
> is made on that GUID across a DB Table to see if the GUID is present.
> There are approx 57,000 GUIDS in said table. It is msSQL DB on
> windows server 2000 server, how long would that check take?
>
> I know there are several variables that come into play here, but I am
> looking for a ball park figure on how long it would and should take.
>
>

Here is a script to allow you to test this on your own server:

USE [test]
GO
/****** Object: Table [dbo].[guidtest] Script Date: 04/13/2008 11:40:01
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[guidtest](
[Guidcol] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT
[DF_guidtest_Guidcol] DEFAULT (newid()),
[Datacol] [int] NOT NULL,
CONSTRAINT [PK_guidtest] PRIMARY KEY CLUSTERED
(
[Guidcol] ASC
) ON [PRIMARY]
) ON [PRIMARY]
go
declare @val int
set @val = 0
while @val < 57001
begin
set @val = @val + 1
INSERT INTO [test].[dbo].[guidtest]
([Guidcol]
,[Datacol])
VALUES
(default
,@val)
end
declare @guid uniqueidentifier
set @guid = (select guidcol from guidtest where datacol = 46598)
select GETDATE()
select guidcol from guidtest where guidcol=(a)guid
select GETDATE()

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

From: Bam on 13 Apr 2008 14:36

"Bob Barrows [MVP]" <reb01501(a)NOyahoo.SPAMcom> wrote in message
news:%23m4IxlXnIHA.3572(a)TK2MSFTNGP02.phx.gbl...
> Bam wrote:
>> Hey gang.
>>
>> Question here:
>>
>> If someone registering for the site, enters their GUID. Now a check
>> is made on that GUID across a DB Table to see if the GUID is present.
>> There are approx 57,000 GUIDS in said table. It is msSQL DB on
>> windows server 2000 server, how long would that check take?
>>
>> I know there are several variables that come into play here, but I am
>> looking for a ball park figure on how long it would and should take.
>>
>> Any ideas??
>>
>>
> Given that the column is indexed, I would expect a result in less than a
> second. But why ask us? Test it for yourself.
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

I wanted to see the time it would take, prior to putting the guids in a
table. I want to use this upon registeration, to see if a player is banned
or not

I will do the test below, and check the results.

thanks Bob

From: Bam on 13 Apr 2008 15:55

"Bob Barrows [MVP]" <reb01501(a)NOyahoo.SPAMcom> wrote in message
news:ekuIf2XnIHA.4536(a)TK2MSFTNGP06.phx.gbl...
> Bam wrote:
>> Hey gang.
>>
>> Question here:
>>
>> If someone registering for the site, enters their GUID. Now a check
>> is made on that GUID across a DB Table to see if the GUID is present.
>> There are approx 57,000 GUIDS in said table. It is msSQL DB on
>> windows server 2000 server, how long would that check take?
>>
>> I know there are several variables that come into play here, but I am
>> looking for a ball park figure on how long it would and should take.
>>
>>
>
> Here is a script to allow you to test this on your own server:
>
> USE [test]
> GO
> /****** Object: Table [dbo].[guidtest] Script Date: 04/13/2008
> 11:40:01 ******/
> SET ANSI_NULLS ON
> GO
> SET QUOTED_IDENTIFIER ON
> GO
> CREATE TABLE [dbo].[guidtest](
> [Guidcol] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT
> [DF_guidtest_Guidcol] DEFAULT (newid()),
> [Datacol] [int] NOT NULL,
> CONSTRAINT [PK_guidtest] PRIMARY KEY CLUSTERED
> (
> [Guidcol] ASC
> ) ON [PRIMARY]
> ) ON [PRIMARY]
> go
> declare @val int
> set @val = 0
> while @val < 57001
> begin
> set @val = @val + 1
> INSERT INTO [test].[dbo].[guidtest]
> ([Guidcol]
> ,[Datacol])
> VALUES
> (default
> ,@val)
> end
> declare @guid uniqueidentifier
> set @guid = (select guidcol from guidtest where datacol = 46598)
> select GETDATE()
> select guidcol from guidtest where guidcol=(a)guid
> select GETDATE()
>
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
I loaded this into a query, then made an asp page to check for one of the
guid's. I am getting an average of 3.5 seconds for this query.

if you would, try this:

first time is time the query started, second time is time it finished. then
it shows the difference.
I am trying to see if where I am located, in respect to the server, makes
that much of a difference.
http://tournaments.acitourneys.info/TIME_TEST1.ASP

| Next | Last
Pages: 1 2
Prev: managing multiple virtual folders of cloned websites
Next: ASP Learning