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]