Date:	2003-01-04 14:19
Subject:	A challenge...
Security:	Public
Mood:	lazy

I've got a little personal project that I'm working on, and I'm looking for some ideas on how to solve a problem that I've run into. The project is a cross-referencing "dictionary" of sorts. Basically, I've got a single database table that stores terms and their definitions. Whenever a user accesses a definition, if that definition contains any of the other terms in the table, I want them to be hyperlinked so that the user can click on them and access their definitions. This is all well and good, but as the database gets bigger and bigger, if I'm having to go through it to dynamically replace terms with hyperlinks at run-time, it'll start to seriously degrade performance. Any ideas on how to get past this wall?