Re: [PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Eddie Drapkin
:* Nitsan Bin-Nun > *Cc:* Jônatas Zechim; php-general@lists.php.net > > *Assunto:* Re: [PHP] phpMyAdmin, localhost, mysql overhead > > > > The better question is why are you using MyISAM tables? Unless there's a > legitimate reason to prefer MyISAM over InnoDB, you should be using

RES: [PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Jônatas Zechim
Assunto: Re: [PHP] phpMyAdmin, localhost, mysql overhead The better question is why are you using MyISAM tables? Unless there's a legitimate reason to prefer MyISAM over InnoDB, you should be using InnoDB. On Fri, Jun 12, 2009 at 2:01 PM, Nitsan Bin-Nun wrote: There is no way to avoid it

RES: [PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Jônatas Zechim
Thank u Nitsan. I’ll proceed with my app now. Zechim De: nit...@binnun.co.il [mailto:nit...@binnun.co.il] Em nome de Nitsan Bin-Nun Enviada em: sexta-feira, 12 de junho de 2009 15:01 Para: Jônatas Zechim Cc: php-general@lists.php.net Assunto: Re: [PHP] phpMyAdmin, localhost, mysql overhead

Re: [PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Eddie Drapkin
; > > > Zechim > > > > > > > > De: nit...@binnun.co.il [mailto:nit...@binnun.co.il] Em nome de Nitsan > > Bin-Nun > > Enviada em: sexta-feira, 12 de junho de 2009 14:33 > > Para: Jônatas Zechim > > Cc: php-general@lists.php.net > > As

Re: [PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Nitsan Bin-Nun
De: nit...@binnun.co.il [mailto:nit...@binnun.co.il] Em nome de Nitsan > Bin-Nun > Enviada em: sexta-feira, 12 de junho de 2009 14:33 > Para: Jônatas Zechim > Cc: php-general@lists.php.net > Assunto: Re: [PHP] phpMyAdmin, localhost, mysql overhead > > > > I haven

RES: [PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Jônatas Zechim
2009 14:33 Para: Jônatas Zechim Cc: php-general@lists.php.net Assunto: Re: [PHP] phpMyAdmin, localhost, mysql overhead I haven't read all your mail, I'm sorry for it in advance, but I think that you should know that "overheard" is just a blasting phrase for something

Re: [PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Nitsan Bin-Nun
I haven't read all your mail, I'm sorry for it in advance, but I think that you should know that "overheard" is just a blasting phrase for something which was made up by phpmyadmin. Basically, when you run a lot of DELETE or UPDATE queries on a table an "overhead" is created, generally speaking th

[PHP] phpMyAdmin, localhost, mysql overhead

2009-06-12 Thread Jônatas Zechim
Hi there, i have this table running on my localhost: CREATE TABLE `caffecheckout_compra_itens` ( `compra_key` varchar(23) NOT NULL, `item_id` int(5) NOT NULL, `item_valor` decimal(10,2) NOT NULL, `item_peso` decimal(5,3) NOT NULL, `item_qtd` int(3) NOT NULL, `item_data` int(10) NOT NUL