- Beranda
- Programmer Forum
[Help] [Mysql] Kueri Count lambat jika timbahin filter kategori
...
TS
alfisyah
[Help] [Mysql] Kueri Count lambat jika timbahin filter kategori
Gan mau nanya nih ,kenapa ya kalau saya jalanin kueri ini
select count(*) as aggregate from `news` where `news`.`deleted_at` is null and `status` = '1'
lebih cepat dibandingi
select count(*) as aggregate from `news` where `news`.`deleted_at` is null and `status` = '1' and `newscategory_id` = '17' ?
ini saya sertain gambar sktruktur table nya
![[Help] [Mysql] Kueri Count lambat jika timbahin filter kategori](https://s.kaskus.id/images/2015/02/11/3388794_20150211105839.jpg)
a gan .
select count(*) as aggregate from `news` where `news`.`deleted_at` is null and `status` = '1'
lebih cepat dibandingi
select count(*) as aggregate from `news` where `news`.`deleted_at` is null and `status` = '1' and `newscategory_id` = '17' ?
ini saya sertain gambar sktruktur table nya
a gan .0
740
5
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.4KAnggota
Urutkan
Terlama
Komentar yang asik ya