writing text file contents into a recordset
Posted: Thu Oct 31, 2002 2:07 pm
How can I speed up the process of reading from text files? I use fopen to open the file and then loop through each line to check something using while(!feof). I use 2 very large text files and it takes forever to finally load my next page with the results. Is there a way (and how?) to create recordsets on the server and load the contents of the files into these? This way I might be able to filter a recordset by using a WHERE clause (for instance "SELECT * FROM rs2 WHERE ID=$row1['StudentNumber']"), instead of having to loop through each and every record.
Please help!
Please help!