Mysql query does not complete the search for all BLOB fields

Question

Good afternoon.

I have a problem that I don’t know what it is. What happens is that I have a list of clients and each client has a mug shot. (Is around 2000 customers)

In my application I do 2 types of backup, 1 of them is searching all the data manually and Serializando them in a file, and the second is using the SGBD itself.

Returning to the problem, when I ask "select * customers", the search simply does not bring me the result. I imagined that it was because of the size of the database that is in almost 300 MB and the application is networked, so I searched the data without the photo of the registration and then searched photo by photo and also did not work, the application starts to bring, but when it comes a little more than half simply stops bringing me results but not any Exception, I can handle the buttons normally, so I don’t know what can be happening much less what I can do to fix this problem.

In short, I do the BLOB data search and if I ask to bring all at once the application stays hours and hours and hours I never bring the result, and if I ask to bring 1 by 1, the application brings up to little more than half and simply stops doing the research and neither goes forward nor back in the code.

Remembering that it is a network application, when I run on local machine everything works perfectly.

Answer 1

What happened was that the JVM was full and could no longer carry data.

To solve I created a file . vbs pra to run . jar using the parameter to increase the JVM’s capacity.

Set Wshshell = Createobject("Wscript.Shell") Wshshell.Run "Java -jar -Xmx2048m.jar file", 0

however when I ran on another machine, the file did not open, so I ran only "Java -jar -Xmx2048m.jar file" in the windows command prompt itself and an error appeared saying that I could not allocate 2048 MB to JVM, so I just reduced the size and it worked.