Re: [PHP] how to make multiple sql run faster

2009-03-22 Thread Davi Vidal

On 03/21/2009 10:19 AM, Andrea Giammarchi wrote:

Hi all,

I am inserting more than 5000 rows into sql database but its taking more
than 30 mins  to get it all the data inserted. I use union to insert
multiple rows of 20 at a time.

What is the best way to make insert sql statement run faster


Usually a single transaction is faster than an insert a time (with or without 
union)



What do you mean?

START TRANSACTION;
INSERT;
INSERT;
INSERT;
COMMIT;

Is that?

Thank you very much

davi

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Re: PHP editor for linux

2008-08-15 Thread Davi Vidal
Em Friday 15 August 2008, Robert Cummings escreveu:
> On Fri, 2008-08-15 at 10:43 -0600, Nathan Nobbe wrote:
> > On Fri, Aug 15, 2008 at 10:40 AM, Richard Heyes <[EMAIL PROTECTED]> wrote:
> > > >> What do you think is the best php editor for linux.
> > >
> > > pico :-)
> >
> > ed baby; its all about ed!
>
> hexedit /dev/sda1
>
> ;)
>

Butterflies. :-)

http://xkcd.com/378/

-- 
Davi Vidal
--
E-mail: [EMAIL PROTECTED]
MSN   : [EMAIL PROTECTED]
GTalk : [EMAIL PROTECTED]
Skype : davi vidal
YIM   : davi_vidal
ICQ   : 138815296

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Top/bottom posting holy war *cringe* (was: New to PHP)

2008-10-13 Thread Davi Vidal
On Monday 13 October 2008 13:44:27 TG wrote:
> I concede only that the PHP list has a requested style (bottom posting).  I
> disagree on it's usefulness OVER top posting.
>

So, this is the only list that you read.

-- 
Davi Vidal
--
E-mail: davividal at siscompar dot com dot br
MSN   : davividal at msn dot com
GTalk : davividal at gmail dot com
Skype : davividal
YIM   : davi_vidal
ICQ   : 138815296


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php