"Abigail" <abigailabigail.nl> wrote in message
news:slrnbg07ro.el.abigailalexandra.abigail.nl...<snippity snip>> fatted (fatted) wrote on MMMDXC September MCMXCIII in
> <URL:news:4eb7646d.0306300038.2be15c80posting.goo gle.com>:
Thanks for replying Abigail.> First of all,
I think it is I want to carry out data access using a Perl script.> that's not a Perl question.
(We could argue that this is a Perl newsgroup not an OS / dbase
newsgroup, but I think from previous posts to the group, usually, people
don't mind briefly discussing these things, especially when popular
modules and built in functions are used).
Data currently is stored in a plain text file on linux system, less than> Second, it depends. It depends
> on how the data is stored, and how you make requests.
600 ascii chars per file, perhaps 100 files. Accessed using perls open
command and <>.
I'm thinking of storing contents of each file in a table, 1 file content
per row. The data would then be accessed using the DBI module interface
to MySQL (select statement). With the provision that a database handle
had already been created (dbase handle used previously in script).
In both cases the MySQL database and plain text files would be stored on
the same machine as the perl script.
I was just wondering whether there would be appreciable differences,> The only way to know for sure is it do some extensive testing, under
> production cirstances.
between the two, perhaps answers of the "Are you crazy doing it like
that, stick to ..." variety (and maybe a because .