General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Yes, that "theory" has now changed - actually since almost 2 years, I think. You must read the threads here more carefully < s >
>
>I guess I missed those ones.
>
>>While it is general concensus that the situation has NOT changed over the years, I remain a doubter on that specific issue. That is, I feel that it HAS TO HAVE CHANGED somewhere along the line.
>>
>>In any case, DELETED() TAG is BAD FORM now with DELETED set ON and especially with bigger tables.
>
>Well, in my case, it's not an issue of big tables. 3000 records with INNER JOIN shouldn't be that much of an issue.
I agree. Are the records big?... would it be worthwhile to return only the fields you actually need (assuming you are doing SELECT *.... now)?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only