been up for 33 hours so forgive me if this seems trivial, I'm fascinated though.
I'm working on a pretty large table, (800k records and climbing) and I'd like to filter said table. The thing is, the table is stored in SQL Server. So, I was wondering, would a
SELECT * FROM table WHERE condition1=true
As long as your SQL server is not paging because of RAM starvation the SQL Server should always be faster than loading the whole table via network and then filtering locally...