BD [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 10:42 AM
To: [EMAIL PROTECTED]
Subject: Re: Speed question.
At 01:17 AM 3/20/2002, you wrote:
>An Oracle DB programmer reviewed a query that I wrote and told me that
>putting constants at the beginning of the que
At 01:17 AM 3/20/2002, you wrote:
>An Oracle DB programmer reviewed a query that I wrote and told me that
>putting constants at the beginning of the query would make it slower. I
>thought I'd go to the experts on MySQL and be told the truth one way of
>the other.
>
>Example query:
>
>SELECT
>
On Wed, Mar 20, 2002 at 12:17:58AM -0700, zxcv wrote:
>
> An Oracle DB programmer reviewed a query that I wrote and told me
> that putting constants at the beginning of the query would make it
> slower. I thought I'd go to the experts on MySQL and be told the
> truth one way of the other.
Perhap
Ok, thanks for the input. I'll work on optimizing the code and look at the
indexes.
ryc wrote:
> Changing to C++ is not likely to give you a noticable speed difference
> because your bottleneck is not the code but the queries. With proper
> database design you should be able to acheive those res
Changing to C++ is not likely to give you a noticable speed difference
because your bottleneck is not the code but the queries. With proper
database design you should be able to acheive those results with one query,
and it should be fast if given the right indexes.
ryan
> I am searching to spee
7 or so. I have indexes on most of the columns being used..
Enrique Vizcarra wrote:
> 1) How large the data base is it? how many records?
> 2) Are you using index?
>
> I has tested MySql serving with Pentium II 266 with Windows 98 2da. Ed.
> operating System and with one table consisting of
1) How large the data base is it? how many records?
2) Are you using index?
I has tested MySql serving with Pentium II 266 with Windows 98 2da. Ed.
operating System and with one table consisting of 762000 records. Even
before I indexed the database, speed of MySql was great. Of course, after
t
No, by multiple queries I mean that I have to querie for every title. The
query is:
Select if(Year<>'"+y+"','1','0') as quest,MM,Archive,record_num from inv where
((REPLACE(Title,'#','')='"+t+"' or REPLACE(Title,'#','')='"+s+"' or
REPLACE(Title,'#','')='"+u+"' or REPLACE(Title,'#','')='"+v+"' or
R
