and would like to ask for some comments wether using mysql or a flatfile database would be more apporiate. I would like to know the difference of using a flatfile and the import text file feature in mysql. are they the same? I haven't had any idea os the import text file feature, so is it better than flatfile? And how do i prepare the contents for importing? I read the MYsql docs but i don't quite understand a bit. LOL.
If you have a lot of information to store your better option is use any relational database (like MySQL).
The reason is simple: if you store the information in a flat file each time you need to retrieve information from it, you have to open the file, read line by line until you find what you want (this could be very slow when you have huge files).
With a database the procedure is the same (unless you are using an index, which is an advance feature of the database) but the routine are optimize to be more efficient.
I agree. Use MySQL if you can. Another advantage is MySQL (or any database) has far better locking property (i.e. to avoid the file being erased when it is modified by more than 1 person at the same time). Trust me, it gave me headache using flatfile
You can import a text file (in tab delimited format) to MySQL to populate your table quickly using either mysqlimport or load data command.
Ok, i'm convinced by now to use mysql. but i have no idea how to have the data written in the way so that mysql can read them. How do i sepearted the columns etc..any help? what do i have to do? I have absolutely no idea. pls help
and the manual dosen't help me at all. LOL