[RESOLVED] PDO singleton class for heavy and light lifting?

gwerner

First off. I've been away from coding for about 6 months. So, I'm relearning a lot of stuff I've already learned. This is what happens when you're a jack of all trades and master of none.

I've been working on a web site that I'm implementing for the first time PDO. I'm really not that well versed with OOP, but I understand the basics of what it is. I'm using the David Soussan PDO singleton class that I dug up on this site to handle the queries.

This class seems to make most queries pretty easy to implement. I'm not sure if I understand everything it exactly does as I said I'm relearning. It uses fetchAll(PDO::FETCH_ASSOC) when selecting data. Is this ok to use if I run a query I know I'll get one row back? I was reading somewhere that fetch was more efficient for single queries, but I might have it wrong.

It seems that it should be ok, since I'm using this for other select queries that will have more than one row returned.

Anyway, thanks for any help offered.

NogDog

It does not sound to me like something to lose sleep over. Worrying about optimization when you're probably talking milliseconds or even just microseconds of difference usually is not worth stressing over -- at least until you reach the point where you're getting hundreds or thousands of requests per second. (And when you reach that point, it's probably cheaper to just throw more hardware at it than development time. 😉 )

gwerner

Ok, thanks. I just wanted to be sure I was going about it in a really bad way. Thanks, and I hear you.

NogDog

That's not to say that if (a) you have any reasonably solid reason to think there would be a performance difference, and (b) you have a little spare time, then you could go ahead and add a separate method for when you expect and only want one result row. It would also have the slight advantage in those cases of returning a 1-D array instead of a 2-D array, making the client code just a tad cleaner. I just wouldn't let it interrupt more urgent work right now if you're under the gun to get something done, for example.