lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marc Kramis" <mkra...@student.ethz.ch>
Subject Re: SqlDirectory
Date Sun, 02 Dec 2001 15:53:17 GMT
here you find the current code:

java:
SQLDirectory.java. (should work with all sql databases via JDBC)

sql:
Oracle: see appended scripts
SQL Server: change varchar2 to varchar, integer to bigint and raw to binary

it seems to be quite stable by now.
the input and outputstream methods should be reviewed.

indexing seems to be a little faster than FSDirectory (both db and files on
remote server)
querying is slower, but included cache increases performance over time or
repeated queries (especially paging)

enjoy ;)
marc



----- Original Message -----
From: "Marc Kramis" <mkramis@student.ethz.ch>
To: <lucene-user@jakarta.apache.org>
Sent: Monday, November 26, 2001 9:38 PM
Subject: SqlDirectory


> hi all
>
> some time ago, there was a short discussion about a database store. I also
> needed some persistence layer that was accessible via JDBC. It turned out,
> that a BLOB implementation is strongly dependent on the RDBMS used and
also
> poorly performing.
>
> I implemented a SqlDirectory, based on the idea of RAMDirectory and its
> buffers as basic element.
> goals:
> 1. should work with all JDBC compliant RDBMS (no adaption required, no
> blobs!).
> 2. performance should be acceptable.
> 3. simple db schema.
>
> status:
> 1. tested on Oracle 8i (free oracle JDBC driver type 4) and SQL Server
2000
> (free microsoft JDBC beta driver type 4). works perfectly.
> 2. consists of 2 tables and 1 index. (one tablespace can have several
> indexes of course)
> 3. promising performance.
>
> todo:
> 1. test reliability, performance, concurrency (multiple reader/writer),
test
> with mySQL
> 2. code review
> 3. introduce caching (maybe CacheDirectory)
>
> if someone has experience or just likes to test it, mail me. Anyway, could
I
> simply attach the SqlDirectory.java file to my mails?
>
> marc
>

Mime
View raw message