HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Search
-
Re: SQL fetching advice needed.
@hbf said: @r_j said: @businessdad said: thanks for the answers you guys - I knew i would get good input. if I am not doing any insertions, deletes or updates. mostly read-only except for a periodic turncate and upload with new data. do you think 16 indexes that combine column 2 and 3, 2 and 4, 2 and 5 thru 2 and 18? would… -
Re: SQL fetching advice needed.
Another perhaps silly question I have 20 items that need to be found either item1 or item2 or item3 or item4 or ..... or item20. these items are all a value in one column of the database. e.g. col 2 is identified as a primary key A ) is it better to do a prepare on select * from mytable where col2 = $itemnumber loop…
2 results