Pros

• CPAN available
• Implement in a short period of time if you have existing databases
• Keeps search information inside the same container as the data

Cons

• Requires knowledge/familiarity with DBI, MySQL, and Perl data strucutures. Which may make it difficult to use for newer users of Perl.
• Only works with MySQL
• Could impact database performance if search is perfromed on the same database as the data in heavily loaded systems.

Performance Results

There is really no reason for me to do this at the scale of the application this was applied to. There is no noticable latency even when the search is performed over 100Mbps connected servers.

Worthwhile

The exercise worthwhile for several reasons:

• Reused existing code
• Provided results that were much more accurate
• Scripts produced will allow for easier future implementations on other projects
• Provided support for search modifiers (AND, OR, +)

Where to use it (will it scale)

• Since I have not done any performance tests I can't possibly predict how far this would scale, but speaking from my own install with roughly 5MB of searched content the seat of the pants performance is acceptable

The system has been online now for 6 months and it has satisified the clients search requirements as well as aided site visitors in locating the information of interest to them. The solution is implemented on a mod_perl enabled Apache server with ~30,000 visitors per month at peak.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.