| || |
flat file vs. MS SQL performance
Is writing to a flat file always going to be faster than writing to MS SQL?
The flat file seems to work instantly. I can output 3000 lines into a flat file using vbCrLf to break lines.
Can a data base file 3000 rows of data any where as near as fast as this?
If I learn to use MS SQL correctly can I get close to the speed of writing to an output file?
a database will get you speed if you need to search and aggregate. Otherwise a flat file is faster.
Have you considered all the intangibles against a DB approach:
Server patching downtime
DB password exipiring
Connectivity from different execution machines/environments
Security of sensitive DB connection details
David and Mark,
The considerations and information were accurate for my situation.