On Wed, Mar 24, 2010 at 4:09 AM, Peter Lind <peter.e.lind@xxxxxxxxx> wrote: > On 24 March 2010 12:04, Tommy Pham <tommyhp2@xxxxxxxxx> wrote: >> On Wed, Mar 24, 2010 at 3:52 AM, Lester Caine <lester@xxxxxxxxxxx> wrote: >>> Tommy Pham wrote: >>>>> >>>>> How exactly will threading in PHP help with the size of the database? >>>>> That makes no sense to me, please help me understand how you think threading >>>>> will help in this scenario. >>>> >>>> Looking at my example, not just the rows.... There are other features >>>> that require queries to a DB for simple request of a category by a >>>> shopper, instead of running those queries in series, running them in >>>> parallel would yield better response time. >>>> >>>>> Database size issues are tackled with clustering, caching and DB >>>>> optimisation. Threading in the language accessing the DB has no advantage >>>>> here. >>>> >>>> Yes, it does. As mentioned several times, instead of running the >>>> queries in series, run them in parallel. If each of the queries takes >>>> about .05 to .15 seconds. How long would it take to run them in >>>> serial? How long do you it take to run them in parallel? >>> >>> Any you have a database that can actually handle that? >>> If the database is taking 0.1 seconds per query, and you have 10 queries, >>> then getting the data is going to take 1 second to generate. If you want >>> some slow query to be started, and come back for the data later, then I >>> thought we already had that? But again this is part of the database driver >>> anyway. No need to add threading to PHP to get the database connection to >>> pull data in the most efficient way. And one does not write the driver in >>> PHP? We are using C there already? >>> >>> -- >>> Lester Caine - G8HFL >>> ----------------------------- >>> Contact - http://lsces.co.uk/wiki/?page=contact >>> L.S.Caine Electronic Services - http://lsces.co.uk >>> EnquirySolve - http://enquirysolve.com/ >>> Model Engineers Digital Workshop - http://medw.co.uk// >>> Firebird - http://www.firebirdsql.org/index.php >>> >>> -- >>> PHP General Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net/unsub.php >>> >>> >> >> Exactly my point. 10 queries taking .1 second each running in serial >> is 1 second total. How long would it take to run all those same >> queries simultaneously??? What's so difficult about the concept of >> serial vs parallel? > > Hmm, just wondering, but how long do you think it will take your > high-traffic site to buckle under the load of the database queries you > want to execute when now you want all of them to execute at the same > time? Going with the "10 queries of .1 second each" ... how far do you > think you can scale that before you overload your database server? I'm > just wondering here, I could be completely off the bat. IIRC, one of opponents of PHP thread mention load balancer/cluster or another opponent mention 'throw money into the hardware problem' > >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > > > > -- > <hype> > WWW: http://plphp.dk / http://plind.dk > LinkedIn: http://www.linkedin.com/in/plind > Flickr: http://www.flickr.com/photos/fake51 > BeWelcome: Fake51 > Couchsurfing: Fake51 > </hype> > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
