Hi Nick:
----- Original Message -----
From: "Nick Arnett" <[EMAIL PROTECTED]>
To: "Brian" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, March 24, 2003 7:47 PM
Subject: RE: Your professional opinion Please...
> > I have a client with approximately 2 gigabytes of
> > un-indexed document files (includes text and graphics).
> > He wants to be able to enter a few parameters and bring
> > up a list of all documents that fit, and then be able to
> > download them over a web interface - sort of like a
> > private Google search engine.
> How many documents?
500+
Documents are added at the rate of ~10 per week.
> What format are they in?
Microsoft Word .docs 80%
Microsoft Excel .xls 10%
Text .rtf 10%
> Does this require just text searching or is there fielded data, too?
There is no fielded data - just a basic text search.
e.g.
Search [Bob Evans]
results: 1020.doc
1024.doc
1030.doc
The ideal situation would to actually provide results like a Google search
for the purpose of downloading the files to the Windows desktop for analysis
and processing and perhaps inclusion in new documents.
> How many users would search
> simultaneously?
There are approximately 12 users at present of which perhaps 5-10 searchs
each per day - very low volume actually.
> There are various search engine vendors, including Google itself.
> The leader is Verity. Autonomy is probably its top current
> competitor. But since you've posted here, are you considering
> MySQL? It doesn't have a particularly rich query language for
> text, and it's up to you to get them into the database in a usable
> form.
I am looking at creating a basic database/index, perhaps employing MySQL but
I am open to any feedback.
This is a low budget project - it is a foot in the door for me.
Thanks for your feedback.
Best regards,
Brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
