"Robert (IMI)" wrote:
> I am currently rewriting alot of my software to use a MySQL database..
> I have a question on a table that I am about to create.. currently I have a flat file
> for each user.. called Global.txt
> In that flat file I have a record that is laid out like this..
> What the flat file does is gets openen when a page is served and decides on the
> colors to put into the body tag..
> Now in a MySQL format it lays out to be around about 54 fields.. there would be one
> record for each user.. with the username as the primary key.. I have created the table..
> but I have not taken the next step to populate the table yet..
> My question is this the best way to do it.. making it a MySQL table or should I leave
> it as flatfiles.. if the performance is going to be about equal I will go with the
> MySQL.. just so I will not have umpteen flat files..
> Robert Saunders
There are only very few cases when a flat file is better than a
database. Generally, flat file is preferable when the data relationships
have near NULL degree of complexity and all of you queries require a
full scan of the dataset.
If those conditions do not apply to you, you will be better off with the