Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Basic Perl trumps DBI? Or my poor DB design?

by TedPride (Priest)
on Oct 23, 2004 at 06:26 UTC ( [id://401776]=note: print w/replies, xml ) Need Help??


in reply to Basic Perl trumps DBI? Or my poor DB design?

SQL and DBI are meant to provide an easy to use interface that saves you coding time. Most database applications require far more time to write by hand than is taken up by all the queries conducted over a year plus. The big question is, do you need that extra speed here? Is maintaining and updating 3000 files worth the extra coding time? In this case, probably yes, since you're already doing the primary database work and just want efficient searching of data. You could, however, put all the data in one file, with a secondary file showing start and end locations for each question set. This would leave you most of your speed without requiring thousands of individual files.
  • Comment on Re: Basic Perl trumps DBI? Or my poor DB design?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://401776]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (5)
As of 2024-04-25 11:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found