[Lxr-dev] [ lxr-Patches-553956 ] File search using filenames stored in DB

[<no...@so...>]

Patches item #553956, was opened at 2002-05-09 00:42
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=390119&aid=553956&group_id=27350

Category: DB backends
Group: Experimental
Status: Open
Resolution: None
Priority: 5
Submitted By: Marco Aurélio Graciotto Silva (magsilva)
Assigned to: Nobody/Anonymous (nobody)
Summary: File search using filenames stored in DB

Initial Comment:
I saw the patch from Shree Kumar and I got quite
amused. I was, till now, using a hack to find files.
With his patches, I saw light at the tunnel's end. I
ported it to  PostgreSQL, quite easy. However, when I
run it, my harddisk screamed and postmaster used all
the cpu for minutes. So I changed the query to
something like this:

("select distinct f.filename ".
           "from files f, releases r ".
           "where r.release = ? ".
           "and f.fileid = r.fileid ");

With this query, everything run much smoother. It seems
to work actually, at least it finds some files.

To this patch work, the find's patch from Shree Kumar
is needed (my patches are only about the db backends)



----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=390119&aid=553956&group_id=27350