dimanche 3 juillet 2016

Better way to get 15 tables results at a time in MySql


I have some 20 tables. These tables have only id(primary key) and description(varchar). But the data is a lot. Almost 400 rows for one table. Right now I have to get data of at least 15 tables at a time. Right now giving call one by one. Means in on session I am giving 15 calls. This is making my process slow. Can any one suggest any better way to get the results from the database. I am using MySQL database and using Java Springs on server side. Will making view for all combine help me ? Need a solution that will fasten my process. The application is becoming slow because of this issue.

Thankyou.


Aucun commentaire:

Enregistrer un commentaire