# Slow query (i think)

**URL:** https://forums.percona.com/t/slow-query-i-think/641
**Category:** Other MySQL® Questions
**Created:** [February 17, 2008, 7:29pm UTC](https://forums.percona.com/t/slow-query-i-think/641 "2008-02-17T19:29:42Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![mxmauro](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@mxmauro](https://forums.percona.com/u/mxmauro)
#### Post date: [February 17, 2008, 7:29pm UTC](https://forums.percona.com/t/slow-query-i-think/641/1 "2008-02-17T19:29:42Z")

</div>

Hi,

I have a query: select \* from articulos\_stock;

and the log for slow queries show this:

# Query\_time: 4 Lock\_time: 0 Rows\_sent: 179529 Rows\_examined: 179529

select \* from articulos\_stock;

So more complex queries involving that table are really slow (like left joining other tables), for eg:

# Query\_time: 8 Lock\_time: 0 Rows\_sent: 179529 Rows\_examined: 718116

SELECT articulos.\* FROM `articulos_stock`  
LEFT JOIN `articulos_talles` ON `articulos_stock`.`Código_Talle` = `articulos_talles`.`Código`  
LEFT JOIN `articulos_colores` ON `articulos_stock`.`Código_Color` = `articulos_colores`.`Código`  
LEFT JOIN `articulos` ON `articulos_stock`.`Código` = `articulos`.`Código`;

Where is the problem? TCP communication is slow? I dont think so because it is on localhost and if in the second query I change SELECT articulos.\* with SELECT COUNT(\*) it tooks 2 seconds… too much for about 180000 rows when some people manages millons.

Machine is Pentium 4 1.8ghz 1,5gb. ram

Best regards,  
Mauro H. Leggieri