Sorry this is still new for me and I'm learning as I go. As I become more
knowledgeable my questions will become more specific and detailed.
Next question:
If I have certain fields within tables that I will be querying often it is
beneficial to set them as indexes for speedier lookups correct? If so, why
is that?
Thanks!
Dan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:59 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Long Running Queries
appropriate indexes would mean indexes on columns specified in your
where criteria.
On this List, people mostly post table structures, as well as the
queries they are firing, or else it really doesn't help.
-Original Message-
From: Danny Willis [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:24 AM
To: Wadhwa, Amit; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: Long Running Queries
What do you mean by appropriate indexes?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:43 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Long Running Queries
You need Appropriate Indexes on the tables.
-Original Message-
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:11 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Long Running Queries
Hello,
I recently began experiencing issues that I would like some assistance
with.
Server Details:
- Windows 2003
- MySQL Max 4.0.20a
I have a table with 450,000+ records in it. When I try to run a single
query, such as selecting 1 row or deleting 1 row using the WHERE clause,
the query can take forever to run. In a specific case, it took 57
seconds to complete the SELECT query.
Any ideas on how to speed this up?
--
Thank You,
Jason Williard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
