Perfomance - DB vs File

[eslater]

From a performance point of view what would be quicker, read a list from a flat file or retrieving it from the database?

Lets assume that the list will contain less than 1000 entries.

Hopefully someone can save me the time from doing a performance test.

Thanks for the input.

Elliot

[James Stanich]

If it's just data you need to access for read-only purpose, I would say a text-file... but if you need search capabilities, relational comparasions, ..., a database may be the option.

[progeix]

a textfile is faster. but as he said, if you need to search, etc.
DB is going to be what you want.