MySQL Forums
Forum List  »  MyISAM

Re: Memory Problem with 1 DB. Other DB ok
Posted by: Gabriel Dunn
Date: January 28, 2015 07:48AM

I don't have any problem running the queries in MySQL via Toad. The strange thing is that the queries seem so lightweight, nothing should have trouble.

From MSSQL, running SELECT MAX(ID) from WP_USERS still gives me the memory error. So does SELECT TOP 1 ID from WP_USERS ORDER BY ID

But, from MSSQL if I do SELECT TOP 10000 * FROM WP_USERS, it works fine. And that is all the columns, not just ID, but NO "ORDER BY"

Seems related to trying to do "ORDER BY"

Options: ReplyQuote

Written By
January 22, 2015 11:15PM
Re: Memory Problem with 1 DB. Other DB ok
January 28, 2015 07:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.