When you have a large of records in the table database, you need to paging it to avoid load all data records with slow speed. Someone’s mistake about pagination in Hibernate with MySQL by using MySQL query normally.
Continue Reading
When you have a large of records in the table database, you need to paging it to avoid load all data records with slow speed. Someone’s mistake about pagination in Hibernate with MySQL by using MySQL query normally.
Continue Reading
There are so many solution to select random record from MySQL table by using rand(). But we should have to know what solution is the simple and best executing. I found this post from Akinas Blog.
Continue Reading
A full-text search allows a search of multiple text columns. If you are setting up a search of a series of articles or a site with lots of product-related content, a MySQL FULLTEXT search can make it very easy to find articles or products related to the keywords used by a searcher. This search method does exactly what its name implies–it allows a full search of large text fields. A FULLTEXT search is easy to set up if you just follow these simple instructions.
Continue Reading