Re: Whats faster? text files or mysql?

Andrew -- ..and then Andrew Fenn said... % % I have two text files with two rows of data on each line sperated by a tab for about 20 lines in each file. Would it be faster accessing this data by putting it in a mysql table? For something so small I'd go with a text file unless you happen to already really know and love your database server -- and it's not doing much anyway. The real time savings will come in your programming and maintenance rather than in file access, so do whatever is easiest for you. My guess is that a straight file, even under something as bad as Windows on an ATA disk, will be faster because of the overhead of talking to the database; DBs shine when they have tons of data, not ounces. HTH & HAND :-D -- David T-G davidtg@justpickone.org http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!