Databases :: MySql :: text files vs mysql |
|||
By: LornaJane  |
Date: 23/09/2003 00:00:00  |
Points: 100 | Status: Answered Quality : Excellent |
|
I am working on a system which stores its data in a series of binary text files full of C structures. There are thousands of these files! I was wondering how text files for data storage compared to mysql (or similar), as I've been working for databases for a few years and haven't used text files before. I know I'm dealing with a lot of data but the files seem slow to access and take up a lot of space (not to mention the fact that they take ages to back up!). I was hoping that you experts out there would let me know what you think about the differences between the two setups, I'd be most interested! |
|||
| By: Squibi | Date: 23/09/2003 03:19:00 | |
Type : Answer |
| Well, I have found that most systems with a lot of text files sooner or later get converted to RDBMSes. Text files do not necesscarily deal well with concurrent accesses, and relating the data between two text files requires a lot of coding, where in SQL you just do a JOIN. If I were start a new app with a lot of data, I would almost always choose a database backend. |
|||
| By: VGR | Date: 23/09/2003 04:57:00 | |
Type : Assist |
| textfiles are good for LINEAR reading databases enable for any access method (ORDER BY...) Performance is also on the side of the RDBMS when data grows larger. |
|||
| By: LornaJane | Date: 29/09/2003 19:17:00 | |
Type : Comment |
| Thanks to both of you for your comments! |
|||
|
Do register to be able to answer |
|||
©2012 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 901 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
