On Tue, Apr 27, 1999 at 06:44:17PM +0000, Jan Cohen wrote:
> I've just more or less been handed one of those
> "hot corporate web projects" that will require some
> outsourcing. Basically, I'll be looking for someone
> to do a relational database that sort of breaks down
> as follows: [specs deleted]
Based on these specs, you do not need a relational database,
or the overhead (cost, space, performance) that comes with
having one. What you're trying to do can be readily done
by stashing the data in associative arrays (hashes) which
are kept in memory. If this landed on my desk, I'd use
Perl to write it (portable, fast, built in hashes) as a daemon
which loaded up its content when it was started up and answered
queries put to it on a particular port.
In other words, we're talking a few hundred lines of Perl
and no disk hits once it starts up. Oughta run *very* fast.
And you've only got 3000 items -- which means that memory
usage is a non-issue. Heck, if the initial try isn't fast
enough, this is easily small enough to make it possible
to hash it by every field, using the differently-hashed
copies to buy performance at the expense of memory.
Of course, you've still got the task of codifying the relationships
between the items in the catalog -- but you will have to do that
anyway, regardless of what software is used to implement this function.
---Rsk
Rich Kulawiec
[EMAIL PROTECTED]
____________________________________________________________________
--------------------------------------------------------------------
Join The NEW Web Consultants Association FORUMS and CHAT:
Register Today at: http://just4u.com/forums/
Web Consultants Web Site : http://just4u.com/webconsultants
Give the Gift of Life This Year...
Just4U Stop Smoking Support forum - helping smokers for
over three years-tell a friend: http://just4u.com/forums/
To get 500 Banner Ads for FREE
go to http://www.linkbuddies.com/start.go?id=111261
---------------------------------------------------------------------
