SQL fetching advice needed.
If anyone can lend some advice.
I've got a database table with about 10,000 records.
with 20 columns (2 columns are 40 characters in length and the other 18 columns are 5 characters in length).
A user will select based on criteria that may result in 5 and Wheres
the results could return a count of potentially 1000 records and all need to be returned on the same html page.
Can anybody give any advice on how many records I could chunk in on one request and process in to an array
without blowing things up in memory,etc.
so the idea would be
I'll probably do my own prepare binding and exec with pdo
what kind of fetching would you use?
any pitfalls or suggestions
any suggestions on database engine that would be optimal.
or a different technique - the only thing that is necessary is all data must be processed out to one html page, no pagination necessary or desired.
I'm also not sure where I would be flushing output buffers.
yes, a bit off - topic
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.