FUDforum: comp.lang.php » transfering all MySQL rows to an array

Home » Imported messages » comp.lang.php » transfering all MySQL rows to an array

Show: Today's Messages :: Polls :: Message Navigator

Re: transfering all MySQL rows to an array [message #176502 is a reply to message #176500]

Sun, 08 January 2012 18:56

M. Strobel
Messages: 386
Registered: December 2011

Karma:

Senior Member

Am 08.01.2012 19:28, schrieb Gregor Kofler:
>>
>> PDO is an abstraction layer, but only at the call level. This is
>> better than none.
>
>
>> I think people only talking about mysql are thinking small. You
>> should not give away flexibility when it comes at small cost.
>
> I know what PDO does. And does not. Flexibility is quite limited. Take a
> query with a LIMIT clause and try to execute it on a MSSQL server. Or
> dealing with date data. IOW: Unless you stick to (really) simple CRUD
> queries, the additional abstraction layer of PDO won't add an awful lot
> of flexibility. Agreed, the interface won't change when switching databases.
>
>> Small cost: the alleged performance of PDO is rather my
>> experience. Additionally the web search turned up in the first hits:
>> http://www.el-bato.de/it/php-mysql-vs-mysqli-vs-pdo-performance
>> (sorry, in german)
>
> I doubt that with your average web application the execution time of db
> calls will be a problem at all. Proper db design, indexing and effort
> put into optimizing the queries themselves will yield much more
> performance gain. (The above benchmarks show that the impact of PDO is
> little with basic queries. How about memory consumption, will the
> benchmarks hold with all data types, etc?)
>
>> Before we start discussing benchmarks I would like to know: what
>> especially do you not like about it?
>
> You stating "the overhead is minimal due to the fact it is a compiled
> extension". Just being a compiled extension doesn't say anything about
> performance penalties (or lack thereof).
>
> Gregor

compiled extension in C vs. extension in PHP.

/Str.

Report message to a moderator

[Message index]

		transfering all MySQL rows to an array By: bill on Sat, 07 January 2012 20:03
		Re: transfering all MySQL rows to an array By: Luuk on Sat, 07 January 2012 20:53
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sun, 08 January 2012 01:06
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 13:54
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sun, 08 January 2012 14:12
		Re: transfering all MySQL rows to an array By: Norman Peelman on Mon, 09 January 2012 00:04
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 08:55
		Re: transfering all MySQL rows to an array By: Norman Peelman on Mon, 09 January 2012 11:59
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 12:05
		Re: transfering all MySQL rows to an array By: bill on Sun, 08 January 2012 11:47
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sat, 07 January 2012 21:07
		Re: transfering all MySQL rows to an array By: bill on Sun, 08 January 2012 11:49
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 14:00
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 17:33
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 17:57
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 18:28
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 18:56
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 19:04
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 23:07
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 00:02
		Re: transfering all MySQL rows to an array By: Erwin Moller on Mon, 09 January 2012 09:58
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 10:09
		Re: transfering all MySQL rows to an array By: Luuk on Mon, 09 January 2012 10:27
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 10:41
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 12:24
		Re: transfering all MySQL rows to an array By: Luuk on Mon, 09 January 2012 12:31
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 10:32
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 12:30
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 12:45
		Re: transfering all MySQL rows to an array By: Arno Welzel on Sun, 08 January 2012 19:31
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 21:43
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 18:22
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Mon, 09 January 2012 01:05
		Re: transfering all MySQL rows to an array By: Peter on Sun, 08 January 2012 17:56
		Re: transfering all MySQL rows to an array By: Denis McMahon on Sun, 08 January 2012 09:39
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Sun, 08 January 2012 10:31
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 14:02
		Re: transfering all MySQL rows to an array By: Denis McMahon on Mon, 09 January 2012 00:18
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Mon, 09 January 2012 01:02
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 03:02
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 09:06

Previous Topic:	sessions timeout
Next Topic:	scoping inside a block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 03:37:31 GMT 2024

Total time taken to generate the page: 0.05573 seconds