 | News Feed |
 | Jobs Feed |
Sections
|
| feed this: |  |
Gonzalo Ayuso's Blog: Performance analysis fetching data with PDO and PHP.
by Chris Cornutt March 28, 2011 @ 08:12:20
Gonzalo Ayuso has a new post to his blog today with the results of some performance analysis he ran when fetching data with PHP and PDO.
Fetching data from databases is a common operation in our work as developers. There are many drivers (normally I use PDO), but the usage of all of them are similar and switch from one to another is not difficult (they almost share the same interface). In this post I will focus on fetching data.
He includes his sample scripts - one using just fetch() and the other using fetchAll() - that include some timing and memory checking logic and includes the results of his "limit 10000" queries from his tables. Not surprisingly, the fetchAll required more memory than the fetch call. Event changing it to a loop of fetch() methods results in about the same amount of memory as a fetchAll.
voice your opinion now!
performance analysis benchmark pdo fetch fetchall memory
Gonzalo Ayuso's Blog: Performance analysis using bind parameters with PDO and PHP
by Chris Cornutt October 06, 2010 @ 08:57:02
Gonzalo Ayuso has posted the results of some performance testing he did with bind parameters in a PDO-based request for his application.
Some months ago a work mate asked me for the differences between using bind variables versus executing the SQL statement directly as a string throughout a PDO connection. Basically the work-flow of almost all database drivers is the same: Prepare statement, execute and fetch results. [...] What's the best one? Both method work properly. The difference is how databases manage the operation internally.
He gives two code examples, one with the bind parameters and one without, and the benchmark code he used to generate his statistics. It uses a PDO connection to execute several statements in a row both with bind parameters and without, measuring the time (with microtime) and outputting the results. His results show that while the simple update is faster, the bind parameter method has the added benefit of reusability for multiple queries.
voice your opinion now!
performance bind parameters pdo analysis benchmark
Blue Parabola Blog: Magento Feature Analysis Series, Part 3 Catalog Browsing Offering
by Chris Cornutt July 17, 2009 @ 08:12:12
Matthew Turland has posted the third part of his series looking at the features Magento, a popular PHP-based e-commerce application, has to offer. This time the focus is on browsing the catalog of available items.
This post is the third part of a series covering the feature set of the Magento PHP-based e-commerce package. In particular, it will review the catalog browsing features. Some of the features in this area are restricted to the Enterprise Edition of Magento. As such, reviewing them required accessing the demo for that edition on the Magento web site.
There's a long list of features that make up this section including things like:
- Layered / Faceted Navigation for Product Filtering in Categories
- Static Block Tool to Create Category Landing Pages
- Unique Design Per Product/Category
- Configurable Search with Auto-Suggested Terms
- Cross-sells, Up-sells, and Related Items
- Product Listing in Grid or List Format
- Breadcrumbs
Take a look at the rest of the post for more features and a summary of three larger issues he found when working with them.
voice your opinion now!
browse catalog analysis feature magento
|
Community Events
Don't see your event here? Let us know!
|