Tag Info

New answers tagged


Frankly, I probably wouldn't use a database in the first place. It doesn't sound like you have any need for ACID, which is one the main things which databases provide and which doesn't come cheap in terms of performance. Nor does it sound like you need complicated indexes. What I would do (and have done, an awful lot) is just loop over the files with Perl ...


To answer your question yes I'm sure it is possible to employ a scheme like jkavalik suggested where you: Import the entire file into a single column/cell in a temp table Parse the malformed csv string using increasingly obtuse trickery as each edge case is discovered. I'm sure a smarter person than me could write an event driven, real-time, web-enabled, ...

Top 50 recent answers are included