HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Search
-
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… -
Re: SQL fetching advice needed.
I reckon he means five where clauses, processed using AND. That is "where X AND where Y AND where Z..." @peregrine I see that you already got excellent answers from @hbf and @R_J. What they write is correct, the amount of data you are dealing with is actually negligible for an RDBMS. I won't go into the topic of why would… -
Re: SQL fetching advice needed.
thank you hbf ok thats a good answer. which leads to another off-topic question is there any kind of tool in php that examines resource usage or profiles. I can certainly put timing in, but I was wondering, if there is something that shows, memory used by an object or any array or memory left. I haven't researched any…
3 results