Re: Perl script into database method?
I'm currently using Postgres under Debian, and have no complaints. It's
plenty speedy. With a catalog that large you might want to go with
something more robust, however.
Pete Templin wrote:
> I'm trying to develop an online ordering system that will allow a
> customer to select from the 110,000 parts offered by our primary vendor.
> In doing so, my initial attempts (using a flat file) take twenty seconds
> for a perl script to search through on an unloaded machine, tearing up CPU
> as it goes. Obviously, the next step is to migrate to an indexed database
> for speed and efficiency (or maybe it isn't - I'm open to suggestions).
> I'm most comfortable scripting in Perl (which isn't to say that
> I'm super comfortable, but...), so I'd like to be able to plug into the
> database directly from Perl. Assuming a Debian 2.0 system (I haven't
> finished my testing and preparation for an upgrade to Debian 2.1), what
> choices do I have, if any?
> Peter J. Templin, Jr., CCNA
> Systems and Networks Administrator
> On-Line Internet Services - URDirect.net
> A division of Global On-Line Computers
> 2414 Babcock Rd. Suite 106 email@example.com
> San Antonio, TX 78229 (210)692-9911
> To UNSUBSCRIBE, email to firstname.lastname@example.org
> with a subject of "unsubscribe". Trouble? Contact email@example.com