MYISAM + Group By

Hello All, I have a MYISAM table (employment_summary) with over 6 Lac records. I use it to do fast keyword searches on employments and want to retrieve the results grouped by the executive. The executive table is also a huge INNODB table and has over 6 Lac records. If I do any join operations

Highlight search keywords in Java

Hello All, I am using MySQL full-text search capability in a java based search application. I have a requirement to highlight search keywords in the results obtained from MySQL database(similar to Google). I found some links to do this using a PHP script. Is this possible to do using Java?

Inner Join on MyISAM table

Hi All, I am using MyISAM storage engine for 2 of the tables in my application so as to use the full text search features. When I join any one of the MyISAM table with other INNODB table, the query is very fast. But, if I do inner join with both theMyISAM table, then the query takes 5 mins to

special char in full-text search

Hi All, I am using the MySQL full text search capability in the search workflow in my appplication. I found that MySQL treats special character like *./,* etc. as tokenizers if they are not specified within a phrase(inside double quotes). For ex. If the search string entered is M.B.A or 24/7

adding conditional stmt using mysql

Hi, I am facing some problems while writing a MySQL query for a complex scenario. I have a table with employments for all executives and a flag to distinguish the current and previous employments(titles in different companies or previous titles in the same company). Here are 2 examples: i.

Re: Slow Query Performance

] wrote: Harini Raghavan [EMAIL PROTECTED] wrote on 10/04/2005 11:17:48 AM: Hi, I am using MYSQL 4.1 database in my J2ee application. I am facing performance issues with some queries that are being run on text fields. Since MYISAM storage engine does not support transactions(and my

Re: Slow Query Performance

can make MYISAM. You'll be adding a JOIN to your queries that need to do the full text search, but it should be a lot quicker and your queries much simpler. You'll then have a mix of InnoDB and MYISAM tables, which is perfectly legal. On Oct 4, 2005, at 11:17 AM, Harini Raghavan wrote: Hi

No of records

Hi, I have implemented pagination for the search functionality in my application. Since I have a lot of data, I thought in memory paging would not be a good option and opted for paging at the database layer. To do this I am retrieving the no of records using the following query and then again

Re: No of records

value later? -Harini [EMAIL PROTECTED] wrote: Harini Raghavan [EMAIL PROTECTED] wrote on 10/05/2005 11:21:26 AM: Hi, I have implemented pagination for the search functionality in my application. Since I have a lot of data, I thought in memory paging would not be a good option and opted

Slow Query Performance

Hi, I am using MYSQL 4.1 database in my J2ee application. I am facing performance issues with some queries that are being run on text fields. Since MYISAM storage engine does not support transactions(and my application requires the database tables to support transaction), I have not been