phpMyAdmin forgets previous SELECT
I'm having a new issue with PMA 4.8.3 (PHP 7.2.7), and I'm hoping someone can suggest a fix.
I have a rather large table (2.4G, about 10 million rows), and I regularly run queries on it to find specific data and then copy a row.
I run something like:
This query usually takes around 0.0013s. I copy one of the rows, and the bottom says "Insert New Row" and then "Go Back to Previous Page". Used to, after the insert it would return back to that SELECT query. But now, instead of returning back to that SELECT query it's loading the entire table, running:
That query takes an average of about 150s! And I have to rewrite the SELECT statement. I'm not sure what changed, but can you guys suggest how I might get it to go back to the previous way, remembering the SELECT query that I'd entered originally?
SELECT * FROM table WHERE colA = 'foo' AND colB = 'bar' ORDER BY postdate DESCThis query usually takes around 0.0013s. I copy one of the rows, and the bottom says "Insert New Row" and then "Go Back to Previous Page". Used to, after the insert it would return back to that SELECT query. But now, instead of returning back to that SELECT query it's loading the entire table, running:
SELECT * FROM table ORDER BY postdate DESCThat query takes an average of about 150s! And I have to rewrite the SELECT statement. I'm not sure what changed, but can you guys suggest how I might get it to go back to the previous way, remembering the SELECT query that I'd entered originally?
Please sign in to leave a comment.
Comments
0 comments