Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: java-user@lucene.apache.org
Received-SPF: pass (nike.apache.org: domain of hiren.t.shah@gmail.com
 designates 74.125.82.176 as permitted sender)
MIME-Version: 1.0
Date: Wed, 11 Apr 2012 02:10:26 +0530
Message-ID: 
 <CAFxQ0zzbHYGGHpnWrE_4a5ypm8SUYa=xzXgfiwEL_v9Mze3a4A@mail.gmail.com>
Subject: Query for "cache" mechanism to used
From: Hiren Shah <hiren.t.shah@gmail.com>
To: java-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=0016e6d59d69fa2edc04bd592124

--0016e6d59d69fa2edc04bd592124
Content-Type: text/plain; charset=ISO-8859-1

I have a requirement to get results of search query within 1 second for a
database table.The database table is returning results slowly at this
point.A table has to be moved to a cache and searched from there so that
search results come fast.I want to do google type page refresh on my
existing search page -- which means the page should refresh as the user
types.
In order to acheive this the search results should return within one
second.My database is teradata.Its queries are taking 2 to 3 seconds at
least.Hence i want to look for other options like caching.I want to use
cache so that the resuls come fast.

Columns are
*company , Id , Industry, parent ...4 more*
Its a search page.So if user types "ja" all items starting from ja like

*company ------------- Id ------------- Industry --------------parent*
jaico ------------- 222 -------------paints ------------- Jaico asia
Jammy fruits------------- 232-------------food------------- jammy
International

The table contains 3.2 million rows and there are 8 columns that are
present.The search data need to return all 8 columns.Considering byte wise
there are 150 chars per row.So total bytes are 3.2 million * 150 chars =
480 Megabytes .I need to store this much data in cache and then fire search
queries like sql (grouping ,like ,order by) across them.What would be the
best option to use in this case

   1. ehcache
   2. jboss cache
   3. Inifinispan
   4. Apache Lucene

Please suggest which option is good .Is it better to do caching in memory
or to use lucene?
*What need to be cached?-->* It is a table of 3.2 million rows with 8
columns.
*Why it is to be cached?-->* It is to be cached so that search results come
*faster* than sql query.If i use sql query it takes very long time.Hence i
want to move towards caching data.

--0016e6d59d69fa2edc04bd592124--