Working with csv files that are 5000 lines or more

[Jim Schaubeck]

My next project is reading in a csv file as large as 7000 lines with 60 items per line.  The "read file..." and "put it into tempvar" command work very quickly.  When I search the data in tempvar, the repeat command works quickly for the first 1000 lines or so then things slow down dramatically.  I tested it with a scrollbar being updated for every line and 1000 seems to be the break point.  Using "Find..." in excel works very quickly but the same file in my stack is slow.  I'll be loading my app onto 20 or so other users so a database may not be an option unless I can load it into the stack (never tried to include an actual database in my apps).

Any ideas on how to search through csv files that are 2000 to 7000 lines?

Thanks in advance
Jim...