What books should you read to learn about sql optimization, java caching, and distribution?

(; swimming skills)
javaweb has been paddling for two years. All I have to learn is to scratch the surface according to the needs of the project. All the skills are dead in the interview. Recently, I can"t feel at ease when I think about it. What skills should I master and what depth should I learn?

  • I, sql, have not written a few words about what kind of sentences will be more efficient in select,. I don"t know how to split tables to improve performance. What books can I read in this area?
  • caching only connects mybatis to ehcache. How much should you know about redis and the like? How else can I use sql cache besides simply doing it?
  • Distribution can only be done by rmi or simply interfacing with the interface of dubbo. How much should you know about things like dubbo or spring cloud?
Mar.30,2021

good time is wasted. If you are interested in the three items mentioned, then I suggest you make good use of sql,sql to have a certain height before studying caching and distribution. after all, it is not enough for sql to write less. Books, in fact, is not the most important, no book can write the actual business scenarios, sap such a powerful system, not according to each customer's actual business scenarios custom development. So books can only provide you with simple ideas, but as for improvement, you have to practice. You have one more advantage than the students at school, you have a company and have a background in actual business needs. You can read any sql book, and after you have the basic knowledge, you can read the code running on the company's server and understand it by 70% to 80%. It will not be a problem for you to go out for an interview.


sql books recommend "High performance MySQL"


I will carry the book list.

< SQL Cookbook Chinese version > there are all kinds of database solutions. The most useful thing in the book is that to consider the solution, we must first make clear whether the database has this function, and then do processing

.
Menu