Can CR handle writing reports off of very large CSV files?
I referring to say 30 million, or 300 million rows?
It would be smarter to import it into a SQL table and attach to that, but I still have to ask.
Thanks for any assistance.
-= Bruce
There is no limit for rows in csv file it's only question of time to import!
It might become a question of system memory?
You don't need to read the whole file into memory :)
Hi Bruce,
That's a lot of rows for any database!
Considering this is flat file, I believe the process would be very slow or it may even come to a point where CR crashes.
-Abhilash
I agree. I just had to ask the question. I've tried it on a much smaller (but still large) file and it's pretty slow.
Justifications etc.
I appreciate the help folks.
-= Bruce
Thank-You folks. I appreciate the great help.
Bottom line: I'm gonna need a sql server table I think.
:-)
-= Bruce