On Sun, Mar 29, 2009 at 10:19 AM, Claudio Nanni claudio.na...@gmail.com wrote:
An explain of the two statements yields the same plan,
anybody knows if they are actually translated in the same plan?
There is a difference. The IN list is sorted so lookups can be done
as a binary search. A bunch
2009/3/29 Oscar ro4...@gmail.com:
Hi all-
I want to know what the difference between IN and OR is under the hood.
select * from dummy_table where id in (2, 3, 4, 5, 6, 7);
select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
id=7;
I've have thought once the query is
. This message serves for
information purposes only and shall not have any legally binding effect. Given
that e-mails can easily be subject to manipulation, we can not accept any
liability for the content provided.
Date: Sun, 29 Mar 2009 09:13:10 +
Subject: Re: IN vs. OR on performance
From: poo
An explain of the two statements yields the same plan,
anybody knows if they are actually translated in the same plan?
Claudio
Ian P. Christian wrote:
2009/3/29 Oscar ro4...@gmail.com:
Hi all-
I want to know what the difference between IN and OR is under the hood.
select * from
Hi all-
I want to know what the difference between IN and OR is under the hood.
select * from dummy_table where id in (2, 3, 4, 5, 6, 7);
select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
id=7;
I run the query sql on the test schema, it seems that there is no
performance
see your table using the
indexes to perform the query.
- Original Message -
From: YL [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Sunday, October 30, 2005 11:16 PM
Subject: Re: 5.0.1 vs 5.0.15: view performance
Thanks a lot Shawn: After adding index, it's
Dear list, I need some inputs/help on my finding below:
5.0.15 make my view (below) almost useless compare with 5.0.1-alpha:
with the same data set, 5.0.15 took 18min but 5.0.1 took 6.3sec to get
the result:
mysqlselect count(1) from unit_address;
+--+
| count(1) |
+--+
|
YL [EMAIL PROTECTED] wrote on 10/30/2005 10:24:24 AM:
Dear list, I need some inputs/help on my finding below:
5.0.15 make my view (below) almost useless compare with 5.0.1-alpha:
with the same data set, 5.0.15 took 18min but 5.0.1 took 6.3sec to get
the result:
mysqlselect count(1) from
At 15:53 -0500 10/30/05, [EMAIL PROTECTED] wrote:
YL [EMAIL PROTECTED] wrote on 10/30/2005 10:24:24 AM:
Dear list, I need some inputs/help on my finding below:
5.0.15 make my view (below) almost useless compare with 5.0.1-alpha:
with the same data set, 5.0.15 took 18min but 5.0.1 took
|
++-+---+--+---+--+-+--+--+-+
3 rows in set (0.11 sec)
mysql
- Original Message -
From: [EMAIL PROTECTED]
To: YL [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Sunday, October 30, 2005 1:53 PM
Subject: Re: 5.0.1 vs 5.0.15: view performance
YL [EMAIL PROTECTED] wrote on 10/30/2005 10:24:24 AM
: mysql@lists.mysql.com
Sent: Sunday, October 30, 2005 1:53 PM
Subject: Re: 5.0.1 vs 5.0.15: view performance
YL [EMAIL PROTECTED] wrote on 10/30/2005 10:24:24 AM:
Dear list, I need some inputs/help on my finding below:
5.0.15 make my view (below) almost useless compare with 5.0.1
Thanks Shawn for the help: The same query took 2min less than before on
5.0.15 after
using inner join. Is what you ask:
mysql show create table address\G;
*** 1. row ***
Table: address
Create Table: CREATE TABLE `address` (
`city`
As I suspected, you have no indexes. You didn't even define a primary key
(PK).
For each table, decide which column or combination of columns you can use
to uniquely identify each row. Make that your PRIMARY KEY for each table.
For other columns or combinations of columns you frequently use in
) unsigned NOT NULL default '0',
.
PRIMARY KEY (`unit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Thanks again
- Original Message -
From: [EMAIL PROTECTED]
To: YL
Cc: mysql@lists.mysql.com
Sent: Sunday, October 30, 2005 9:25 PM
Subject: Re: 5.0.1 vs 5.0.15: view performance
Marcin Lewandowski [EMAIL PROTECTED] wrote on 02/08/2005 05:29:39 PM:
Chuck Herrick napisa(a):
200 - 400 tables is too many.
Is it too many for merge, innodb or both?
Try having one CUSTOMERS table. You know who is logged in, so you can
use that information in a WHERE clause.
Yes,
Hi,
I'm writing an windows app, which would connect to mysql server and
modify user's data. There would be a few hundred of users. Every of them
should have access only to few tables. It's not a problem with mysql's
authentication mechanism.
Kind of compilation of the data from users' tables
Chuck Herrick napisa(a):
200 - 400 tables is too many.
Is it too many for merge, innodb or both?
Try having one CUSTOMERS table. You know who is logged in, so you can
use that information in a WHERE clause.
Yes, but If somebody would find a password (maybe using brute-force
attack) to one
Hello,
I'm considering building a dual athlon or dual xeon machine.
Which gives better results for mysql queiries using LIKES on
text columns? (under linux)
Currently availabe athlon 2.2 (1.8 ghtz) or Xeon 2.8?
Anyone run any numbrs between the two?
Thanks,
John
Hey guys,
Most of the accounts I have read about MySQL was that it was one of the fastest
databases around. Now, for development purposes I created a FreeBSD system with JUST
MySQL (no other major processes). Then I created a separate Windows 2000 ASP server to
server as our development
On Tue, Mar 27, 2001 at 02:12:36PM -0800, Steve Quezadas wrote:
Anyways, a period of time elapsed and we decided to move to MS-SQL
server for feature reasons, and when we had the MS-SQL ODBC driver
point to the newly created MS-SQL server (roughly same specs), it
was like 50% faster! What
: Tuesday, March 27, 2001 4:18 PM
To: [EMAIL PROTECTED]; Steve Quezadas
Subject: Re: MySQL vs MS-SQL performance
Steve,
I also experienced the same results you did until I realized that
the MS-SQL connection was using pooled connections and my
use of MySQL wasn't. After I started using persistent
21 matches
Mail list logo