CODEWITHSUNDEEP
mysqlmariadbnavicat
MPetrovic
MPetrovic

Reputation: 171

Navicat message - out of memory

i have table with about 4 million rows, and each rows consist of 30 columns. It should every day to table become bigger and bigger with new rows.

When i want to see all data in navicat browser on 2.5 million it gives me message out of memory, in my opinion, it has nothing to do with server resources?

Also, i tried right click on connection -> Execute sql file, it runs succesfull, but it does not show data.

Upvotes: 0

Views: 3689

Answers (1)

O. Jones
O. Jones

Reputation: 108841

You have a large table. When you try to retrieve the whole contents of the table as a result set, it seems your client software (Navicat) can't get enough RAM to hold it.

The entire purpose of SQL is to allow the handling of very large tables: specifically tables that don't fit in RAM. So, it doesn't make sense to pull your whole table into a client.

If you must retrieve the whole table for some reason, try the mysqldump command line file, and put it into a file.

You may wish to use the LIMIT 1000 clause or some such thing at the end of your queries from the client program.

Upvotes: 1

Related Questions