I need to perform a query on a MySQL database.
The table is very heavy and so the best way to query it is to write something like:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT * FROM MYTABLE where ID > :sql_last_value LIMIT 5000;
Since this is not a single statement, I cannot use it on the statement field.
How can I manage that?