[eluser]deco10[/eluser]
So I have a bunch of data in a csv file. This data will change... never.
This data includes a list of "names" and then pdf files that correspond to them. I don't want to rename the PDFs although that would be one way to solve them.
The table I'm using has 50k entries and may grow some but not significantly. Each line has some prices, description, manufacturer name (there are about 30 manufacturers across the 50k records).
When I print the query results, I print the the manufacture name as a link to the PDF.
I just realized it would be practical to load the csv data into an assoc array and just use the manufacturer name as the key. This way I would only have to read the csv once. But even with this improvement, I wonder if there is a more efficient way, as a user may perform hundreds of searches a day. (its an intranet site for a very busy sales dept).
Suggestions?
