Hi, You may have the same table structure in MS, but not the same table definiton : constraints+indexes+stats !
try : create index toto on Barang(BrgId, Kode, Barang); Select BrgId, Kode, Barang From Barang Group By Barang Having Count(*) > 1 ; Mathias Selon Hendro Suryawan <[EMAIL PROTECTED]>: > Hi, > I have 8414 records in table name Barang, I run query like this : > > Select BrgId, Kode, Barang From Barang Where Barang in > (Select Barang From Barang Group By Barang Having Count(*) > 1 ) > > and the answer took 54813 ms. I think is too long. I ran the same query > against same table in MS SQL Server it took 1 second. Does anyone have > any idea? > > I have mysql on FC 3 X86_64 on Athlon 64, RAM 512 MB. > Table Definition : > CREATE TABLE `Barang` ( > `BrgId` int(4) NOT NULL default '0', > `Kode` varchar(11) NOT NULL default '', > `Barang` varchar(70) NOT NULL default '', > `Satuan` varchar(10) default NULL, > `Stok` decimal(10,0) default NULL, > `Nilai` decimal(10,0) default NULL, > `Lokal` char(1) default NULL, > `SGrupId` int(10) NOT NULL default '0', > `StokMin` int(10) default NULL, > `Catatan` blob, > `Benda` char(1) NOT NULL default '', > `Gambar` longblob, > `LastTrans` date default NULL, > `Operators` varchar(50) default NULL, > PRIMARY KEY (`BrgId`), > UNIQUE KEY `Kode` (`Kode`), > KEY `Barang` (`Barang`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > > thanks, > Hendro > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > 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]
