Hello again all. Thanks for the help on the query time issue, I have
begun a transition.
I have another question. I have some queries which are apparently going
into a Sleep mode in my database. Can anyone point me in the right
direction on this for more information?
Thanks,
Darren
If say, that client closes the connection at some point in the
future...that will clean up then? Or has the connection been severed?
-Original Message-
From: James Montebello [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:59 PM
To: Greer, Darren (MED)
Cc: '[EMAIL
Hello all. I have a database which is around 10million rows. The
structure is as follows:
id int(11) NOT NULL- Auto Increment
address char(90) NOT NULL
status char(2) NOT NULL
country char(2)
state char(2)
areacode char(3)
...about 40 char(1) fields.
I have an unique index on address,
Correction on the query: SELECT count(*) as count FROM userdata WHERE
status = 'A';
Sorry.
-Original Message-
From: Greer, Darren (MED)
Sent: Tuesday, January 08, 2002 10:20 AM
To: '[EMAIL PROTECTED]'
Subject: General Query time question
Hello all. I have a database which is around
Stancescu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:37 AM
To: Greer, Darren (MED)
Cc: '[EMAIL PROTECTED]'
Subject: Re: General Query time question
I'm just guessing here, but I suppose most of the char(1) fields are y/n
fields. If that's the case you should consider using
If I move the status to another table, and then wanted to get a count of
everyone who is of status 'A', how would that be any quicker? Would I
join the tables?
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 11:34 AM
To: [EMAIL PROTECTED]