Rndblog - rndblog.com - Research And Development Blog
General Information:
Latest News:
Deleting batch of rows from MS-SQL Server table 22 May 2013 | 05:44 pm
Deleting large number of rows from a (SQL Server) table can cause replication delay, create a very large transaction and a big performance impact, as well as escalating locks so that the table will be...
Hibernate: How to insert OneToMany children by cascade 5 Aug 2012 | 02:57 pm
I needed a way to insert an entity with a new joined (children) entity together. One way to do it is by separate the actions (e.g. to save the joined entity first and then to save the main entity). Ho...
Solr spellcheck compound from several fields 18 May 2012 | 04:27 am
The Solr’s SpellCheck component is designed to provide inline spell checking of queries (i.e. query suggestions or “Did You Mean”) in case it thinks the input query might have been misspelled. The wor...
How to create a copy of existing Solr index 3 May 2012 | 08:11 am
If you have an already existing Solr index and you want to try new settings, it is best to work and test on a copy Solr’s index first. Here are the simple steps to make a copy of your Solr’s index: Su...
Drupal Sitemap does not show URL aliases 24 Jan 2012 | 09:58 pm
The Sitemap module The Drupal Sitemap module generates a sitemap page and gives visitors a site overview. All categories and terms (i.e. vocabulary) are expanded optionally with node counts and RSS fe...
How to log all MySQL queries in Drupal 23 Dec 2011 | 02:16 am
In order to benchmark a Drupal site performance you need to see all the database queries related to your Drupal site. In case you don’t have access to the my.cnf file If you don’t have access to the m...
Insert into multiple MySQL tables with one-to-one relationship 21 Jun 2011 | 06:14 am
I have been asked if there is a way to insert data into two MyISAM tables that connected by a one-to-one relationship in one MySQL query. For example: mysql> CREATE TABLE `user` ( `id` int(10) unsigne...
Connection Pool: MySQL Communications link failure 2 Jun 2011 | 12:26 am
The Problem And The Solution While using a MySQL connection pool in Java, I received a MySQL Communications link failure Exception (see below). In order to solve communication link failure exception: ...
Connection Pool: MySQL connection closed exception 1 Jun 2011 | 12:49 am
The Problem While using a MySQL connection pool in Java, I received a MySQL Connection Closed Exception (see below). The problem was that the JDBC driver was not compatible to the MySQL server version...
How To Switch Java in Centos 29 May 2011 | 06:17 pm
* If you need to install a new version of java, download the version from java.sun * run /usr/sbin/alternatives to change the default java. If you will run the next command you will see which java ver...
