Re: [PBML] Databases - Flat File vs Relational
>>>>> "Andy" == Andy Schafer <lostgameparts@...> writes:Andy> First I want to say that I am pretty new to Perl and do not know much
Andy> at all about relational databases. However, I am the kind of person
Andy> who likes to go in depth with whatever I am working on. I also know
Andy> that this debate has been covered a lot here and elsewhere and I have
Andy> read through a lot of posts on the subject. However, I still have some
Consider DBM::Deep which will effectively put a hash or more complex structure
out on disk for you. Then you can use normal hash access to get what you
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
- --- In email@example.com, "Andy Schafer"
> OK, I have a retail website that I have been running for a while. Ieach
> have roughly 1000 different part numbers and more to come. I built a
> simple flat file database to keep track of everything and wrote a
> script that will keep quantities updated, give me editing
> capabilities, and also generate all of the html display pages for
> category with one click of a button. All of this is pretty crudelyhave
> written but it works well and I have been very happy with it.
> I am always thinking of new features and such and have decided to
> redesign my database to include these new ideas and more. I also
> learned a lot more Perl since I wrote the original scripts so itwill
> be a lot more efficient and organized.page.
> My plan is this: each file in my database will hold 1000 parts. Each
> page or group of pages will be designated for a certain category of
> parts. Finding the proper page in the database will simply involve
> taking the part# and removing the last 3 digits. This gives the
> I then will load the page into a hash ...thing
> So, my questions are:
> 1 Is there a significant increase in speed if I do this kind of
> in a relational database?I would expect to get one, yes.
The easiest to install and powerfull enough for this is in my opinion
SQLite. Or rather DBD::SQLite ... the database engine is included in
the module. I do think this will not only be quicker and scale
better, but also simplify your code.