We don't bite newbies here... much | |
PerlMonks |
Re: mySQL or Flat Files, Which is fasterby gmpassos (Priest) |
on Feb 08, 2004 at 23:09 UTC ( [id://327515]=note: print w/replies, xml ) | Need Help?? |
If you want something between a server DB and flat files, take a look at SQLite (DBD::SQLite).
Talk about speed and DB is not simple. For example, if you make your own flat system, to store your data, for a specific use, with a goo data structure approach, maybe you can have something faster and light than a true DB. But speed depends also in how you access a DB. For example, if I want just the register N of my flat file, this will be fast. But if you want to make a complex search in your data, a DB exists for that. But I still recomend SQLite. If you don't want to use a server DB, like MySQL, but still have SQL queries, tables, and speed, SQLite works very well. The only limitation of SQLite is that it won't work in multiple systems, soo, you can't have in the future a DB system that work with multiple servers. With SQLite you only can have one machine working with the file. Unless you make some network to share a HD/directory of the SQLite file. Unsing SQLite you also will be still using DBI, soo, if in the future you need to change the DB will be easier.
Graciliano M. P.
In Section
Seekers of Perl Wisdom
|
|