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.
well, based on my experience with MS-SQL, MySQL and developing my own XML based data services.. if i assume you will have 0 indexing and each where clause will require a full traversal of the table then the maximum number of records is completely irrelevant to the memory utilization since you will load the entire table to… -
Re: SQL fetching advice needed.
If you really have to filter by (potentially) any and every column, then you might be better off indexing each column separately, rather than creating combined indexes. However, I would advise against indexing any column that can only contain few values, such as Yes/No, M(ale)/F(emale), 0/1 and so on. This is because, when…
2 results