Hello.
On Tue 2002-07-16 at 07:47:33 -0500, [EMAIL PROTECTED] wrote:
> >> Of the data? Or of the queries?
> > Not the data. Just your query, the output from explain and a create
> > table statement.
>
> Query:
>
> SELECT DISTINCT cards_crypt.*
> FROM user_haves, cards_crypt WHERE
> cards_cryp
>> Of the data? Or of the queries?
> Not the data. Just your query, the output from explain and a create
> table statement.
Query:
SELECT DISTINCT cards_crypt.*
FROM user_haves, cards_crypt WHERE
cards_crypt.name LIKE "%harrod%" AND
user_haves.card_name = cards_crypt.name AND
user_haves.tota
On Monday, 15. July 2002 22:46, Chris Boget wrote:
>
> Of the data? Or of the queries?
>
Not the data. Just your query, the output from explain and a create table
statement.
Regards
Georg
-
Before posting, please check:
ssary
before drawing any conclusions.
IMHO,
Steve Orr
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:39 PM
To: Chris Boget; [EMAIL PROTECTED]
Subject: RE: MyISAM v. InnoDB
switching to InnoDB won't help. Take a look at optimizing your que
Can you post your query along with the output of explain?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 3:45 PM
To: Cal Evans; [EMAIL PROTECTED]
Subject: Re: MyISAM v. InnoDB
> switching to InnoDB won't help. Take a look at optimizing your
> queries. Are you using LIKE?
In some queries, not all.
> have you looked at the output of EXPLAIN?
Yes, but I don't understand much of what it really means.
Chris
MySQL
---
>> When dealing with a considerable number of records (10s of
>> thousands) in a particular table, which is better to use? Currently
>> we are using MyISAM and the queries on those tables are kind of
>> slow.
> Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the
>> When dealing with a considerable number of records (10s of
>> thousands) in a particular table, which is better to use? Currently
>> we are using MyISAM and the queries on those tables are kind of
>> slow.
> Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the
On Mon, Jul 15, 2002 at 01:52:46PM -0500, Chris Boget wrote:
>
> When dealing with a considerable number of records (10s of
> thousands) in a particular table, which is better to use? Currently
> we are using MyISAM and the queries on those tables are kind of
> slow.
Really? That's not a lot of
switching to InnoDB won't help. Take a look at optimizing your queries. Are
you using LIKE? have you looked at the output of EXPLAIN?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15,
10 matches
Mail list logo