Slow DB queries with MS-SQL

The issue is your query as burgoyn1 wrote. Put the query in your DB app and run an explain on it. It's doing full table scans you need to add indices.

Drawing it is a separate issue. The more complex the markup the slower the browser will paint the page. You shouldn't be drawing 17k rows on one page. Paginate it or infinite scroll and load a few hundred at a time.