Back in May I explained how to create MySQL striped views with session variables. A couple folks wanted to know how to implement them through PHP programs. The trick is sharing the same connection between a call to the function before a query against the striped view.
I’ve updated the MySQL example beyond the Hobbit analogy from the prior post. It now uses the following database components:
- A striped
FUNCTION_QUERYview to optimize function calls
The definition of the
APPLICATION_USER table is:
CREATE TABLE application_user ( user_id …[Read more]