473,320 Members | 1,802 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Generally Question

Bam
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
Jun 27 '08 #1
9 1498
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"
Jun 27 '08 #2
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=@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"
Jun 27 '08 #3
Bam


"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:%2****************@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
Jun 27 '08 #4
Bam
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:ek**************@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=@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
Jun 27 '08 #5
Bam wrote:
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:ek**************@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:
<snip>
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
Why would that make a difference? I assume you are timing the query
execution in your server-side code. The location of the client is totally
irrelevant.

I strongly suspect that the extra 3+ seconds is due to the time it takes to
send the query to the server and the the time taken to receive the results.
When I tested that script on my machine (using SSMS) I got results
instantaneously - zero time. Were your results similar when you tested it
without asp involved?

--
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"
Jun 27 '08 #6
Bam


"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:et**************@TK2MSFTNGP02.phx.gbl...
Bam wrote:
>"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:ek**************@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:
<snip>
>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

Why would that make a difference? I assume you are timing the query
execution in your server-side code. The location of the client is totally
irrelevant.

I strongly suspect that the extra 3+ seconds is due to the time it takes
to send the query to the server and the the time taken to receive the
results. When I tested that script on my machine (using SSMS) I got
results instantaneously - zero time. Were your results similar when you
tested it without asp involved?

yes, when directly on the server, it was real fast. I am doing this as part
of a registration, so I needed to know the time of the delay for an actual
user upon registering.

You have helped me find the answer, and I thank you for that.

Just out of couriosity, when you ran the script you just gave me, how long
did it take to create the table, and post the data to the DB from the
query??
Jun 27 '08 #7
Bam wrote:
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
>>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

Why would that make a difference? I assume you are timing the query
execution in your server-side code. The location of the client is
totally irrelevant.

I strongly suspect that the extra 3+ seconds is due to the time it
takes to send the query to the server and the the time taken to
receive the results. When I tested that script on my machine (using
SSMS) I got results instantaneously - zero time. Were your results
similar when you tested it without asp involved?

yes, when directly on the server, it was real fast. I am doing this
as part of a registration, so I needed to know the time of the delay
for an actual user upon registering.

You have helped me find the answer, and I thank you for that.

Just out of couriosity, when you ran the script you just gave me, how
long did it take to create the table, and post the data to the DB
from the query??
About a minute, maybe a few seconds more.

Err, that's not the part of the query you should be running from ASP ... but
if you are running it and getting the results after inserting 57K records in
3.5 sec. you whould be extremely happy with your server's performance.

--
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"
Jun 27 '08 #8
Bam

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
Bam wrote:
>"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
>>>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

Why would that make a difference? I assume you are timing the query
execution in your server-side code. The location of the client is
totally irrelevant.

I strongly suspect that the extra 3+ seconds is due to the time it
takes to send the query to the server and the the time taken to
receive the results. When I tested that script on my machine (using
SSMS) I got results instantaneously - zero time. Were your results
similar when you tested it without asp involved?

yes, when directly on the server, it was real fast. I am doing this
as part of a registration, so I needed to know the time of the delay
for an actual user upon registering.

You have helped me find the answer, and I thank you for that.

Just out of couriosity, when you ran the script you just gave me, how
long did it take to create the table, and post the data to the DB
from the query??

About a minute, maybe a few seconds more.

Err, that's not the part of the query you should be running from ASP ...
but if you are running it and getting the results after inserting 57K
records in 3.5 sec. you whould be extremely happy with your server's
performance.

--
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"
No, the query was done in the DB itself. it took 28 seconds to populate the
fields when I ran it. the 3.5 seconds is based on the asp script finding a
specific GUID from a webpage.
Jun 27 '08 #9
The entire process should take milliseconds. That is, take an ASP page
without any db interaction that does a submit as a baseline. Then add the db
query. A few extra milliseconds

Jeff

"Bam" <ba*@gig-gamers.comwrote in message
news:48**********************@roadrunner.com...
>
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
>Bam wrote:
>>"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcomwrote in message
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

Why would that make a difference? I assume you are timing the query
execution in your server-side code. The location of the client is
totally irrelevant.

I strongly suspect that the extra 3+ seconds is due to the time it
takes to send the query to the server and the the time taken to
receive the results. When I tested that script on my machine (using
SSMS) I got results instantaneously - zero time. Were your results
similar when you tested it without asp involved?
yes, when directly on the server, it was real fast. I am doing this
as part of a registration, so I needed to know the time of the delay
for an actual user upon registering.

You have helped me find the answer, and I thank you for that.

Just out of couriosity, when you ran the script you just gave me, how
long did it take to create the table, and post the data to the DB
from the query??

About a minute, maybe a few seconds more.

Err, that's not the part of the query you should be running from ASP ...
but if you are running it and getting the results after inserting 57K
records in 3.5 sec. you whould be extremely happy with your server's
performance.

--
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"
No, the query was done in the DB itself. it took 28 seconds to populate
the fields when I ran it. the 3.5 seconds is based on the asp script
finding a specific GUID from a webpage.

Jun 27 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Netty | last post by:
Today I posted the following but have a general question... "Apologies for the long post. There are three HTML Trans sites I regularly visit, each of which require a) my choice from a datatable,...
7
by: Richard Cavell | last post by:
Hi, The point of using const on a parameter to a function should be to let your compiler know that the parameter shouldn't be modified during your program. This allows you to keep your code...
71
by: Greg | last post by:
Is it your general opinion that C# is generally designed/intended/ready to replace C++? I know the answer is not black and white but please repond YES or NO (add any comments if you would like) ...
13
by: Sameer | last post by:
Hi friends, I am beginner in C++. I am using g++ compiler. below is my code which gives error as " invlid conversion from 'char' to 'const char*' ..Plz help me with this. #include <iostream.h>...
21
by: T.A. | last post by:
I understand why it is not safe to inherit from STL containers, but I have found (in SGI STL documentation) that for example bidirectional_iterator class can be used to create your own iterator...
6
by: MLH | last post by:
I have frmMainMenu with the following two code lines invoked on a button click... 2420 DoCmd.OpenForm "frmVehicleEntryForm", A_NORMAL, , , A_ADD, A_NORMAL 2440 DoCmd.GoToRecord , , A_NEWREC ...
6
by: Troels Arvin | last post by:
Hello, I have recently run a rather large data import where the imported data i pumped through some updatable views equipped with INSTEAD OF triggers. For various reasons, the exact same data...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.