Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Adam Douglas writes:
Sinisa cut
Alright, but is there no way then to decrease my query time of 14 seconds
(includes 3 queries) to something more reasonable for use on-line? 10
seconds according to stats is the maximum
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Adam Douglas writes:
cut
Another thing that happens is when I tried to ALTER PostalCodeInfo and
PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage
at 99.0% to 99.02% (never ending it seems). Both
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Adam Douglas writes:
I'm running MySQL v3.22.32. Here's my problem I run the following
select query and both CompanyRep and PostalCodeInfo tables are not
using my Indexing. Why? How can I get these two tables to use indexing
Adam Douglas writes:
Ahh what do you mean all tables are not related with common columns? They
are not suppose to be related with a common columns. PostalCodeInfo and
Company table are completely two different things.
Yes that is correct, I've resolved the issue with PostalCodeInfo for
Adam Douglas writes:
Correct 6 tables are being joined. Here's the explain of
the query below
(btw, I'm not getting a index on CompanyShipInfo and
PostalCodeInfo not
CompanyRep like I previous said). Excuse me if this seems
dumb but I'm not
sure what you are saying in the last two
I'm running MySQL v3.22.32. Here's my problem I run the following
select query and both CompanyRep and PostalCodeInfo tables are not
using my Indexing. Why? How can I get these two tables to use indexing
to speed up my query. You can look at my indexing on the two tables
below the query.
Any
Adam Douglas writes:
I'm running MySQL v3.22.32. Here's my problem I run the following
select query and both CompanyRep and PostalCodeInfo tables are not
using my Indexing. Why? How can I get these two tables to use indexing
to speed up my query. You can look at my indexing on the two tables
Adam Douglas writes:
I'm running MySQL v3.22.32. Here's my problem I run the following
select query and both CompanyRep and PostalCodeInfo tables are not
using my Indexing. Why? How can I get these two tables to use indexing
to speed up my query. You can look at my indexing on the two tables
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 1:27 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Query Not Using Indexing
Adam Douglas writes:
I'm running MySQL v3.22.32. Here's my problem I run the following