Working with Prepared Queries with PDO Objects in PHP 5
Monday, June 11th, 2007Using Unbuffered Queries and More with SQLite with PHP 5
Monday, December 11th, 2006Are you one of those PHP developers looking for a tight and powerful RDBMS other than MySQL in order to build your next database-driven website Then hopefully your search is finished. Welcome to the second installment of the series Using SQLite with PHP 5. Comprised ...
Multi-Table Queries with Oracle 10G XE
Wednesday, November 29th, 2006Queries are quantitative questions you pose to a database. Questions such as how many employees make more than 2 . a year or which employee has worked for more than two years are typical examples. In some ...
Analyzing Queries for Speed with EXPLAIN
Friday, August 11th, 2006When you are trying to optimize your queries to run quickly and efficiently you may encounter queries that really should run faster. That s where EXPLAIN comes in handy. This article shows you how to use EXPLAIN in query analysis. It is excerpted from chapter 13 of the ...
Optimizing Queries with Operators for Date, Time and Other Functions
Thursday, April 13th, 2006This article will give you a good grounding in operators branching and functions in MySQL so you can make the database instead of your own code do the bulk of the work. It is the third of three parts and excerpted from chapter four of ...
Optimizing Queries with Operators, Branching and Functions, continued
Thursday, April 6th, 2006This article will give you a good grounding in operators branching and functions in MySQL so you can make the database instead of your own code do the bulk of the work. It is the second of three parts and excerpted from chapter four of ...
Optimizing Queries with Operators, Branching and Functions
Thursday, March 30th, 2006This article will give you a good grounding in operators branching and functions in MySQL so you can make the database instead of your own code do the bulk of the work. It is the first of three parts and excerpted from chapter four of ...
