Re: [PHP] how to make multiple sql run faster
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
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)
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