[phoenix-dev] DB API regression

[Denis Roy <denis.roy@xxxxxxxxxxx>]

The Database API that we implemented a few months ago introduced a regression.  In order to increase performance and scalability, the API redirected SELECT queries to the slave database server.  However, time-sensitive queries (such as INSERT from a POST, then SELECT on the next page) may be affected by a lagged slave server.

Under those circumstances, you can now force low-overhead, time-sensitive queries to be executed on the master by adding this SQL comment immediately after the SELECT:

/* USE MASTER */

Please see the Phoenix docs for more information:

    http://wiki.eclipse.org/Using_Phoenix#Querying_the_master_database

Denis

--
Denis Roy