i have PHP serve and one csv file .
i need to read csv file and send the data to the browser.
if individual request = 10,000 or more (may be) then reading csv file from harddisk may be costly.how can i efficiently read csv file from PHP and send the data to the browser.
there is no option to read data form relational db.
only browser<------------->PHP(apache)<---------------->CSV
flow pattern.
views:
28answers:
1
+1
A:
Honestly, a DBMS would be much better at load-balancing and handling multiple requests for the same data than a CSV.
If you honestly and truly cannot use a DBMS, then I'd suggest storing the file in some sort of memory cache, so it isn't reading from the disk every time it goes to retrieve information. Perhaps. also, storing the data in the format it returns to the client would help.
amphetamachine
2010-05-23 05:38:29