Re: Databases - Flat File vs Relational
- --- 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.