CODEWITHSUNDEEP
mysqlview
Jason Samuels
Jason Samuels

Reputation: 971

What is the size limit for a Query/View table in MySQL?

I am using MySQL and currently have 3 tables in a database. I created a view table with relationships between the 3 tables. The view table should be about 200 000 rows of data because i also tested the same query in Access and it works fine, but unfortunately i am not allowed to use Access.

When i build the view in MySQL i get a message that says the view was build successfully. But when i try to actually view the data, it gives me something like, MySQL ran out of memory. I am not sure what i can do differently to avoid this message. Can someone please give some advice?

Upvotes: 3

Views: 618

Answers (1)

Rahul Tripathi
Rahul Tripathi

Reputation: 172578

You can use the Quick option for running your query.

Do not cache each query result, print each row as it is received. This may slow down the server if the output is suspended. With this option, mysql does not use the history file.

Upvotes: 1

Related Questions