#18 File search using filenames stored in DB

[Marco Aurélio Graciotto Silva]

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)

[Marco Aurélio Graciotto Silva]

DB Backed patches for file search

[Shree]

Logged In: YES
user_id=142912

I had observed the same problem and used the same solution...
[ My Win2k server machine would almost hang when anyone did a file search]
I thought that I had posted the modified patch - seems as if I
forgot... Too bad!

Nice to know that it's working for you, though.

[Malcolm Box]

Logged In: YES
user_id=215386

Thanks for the patch. At the moment I don't have access to
a system that I can apply this on, so it may be a while
before this shows up in CVS.