Wednesday, December 26, 2012

Long SQL queries

Over the holidays I ran a small script against SQL Server. Basically spatial queries. I ran the script in pieces to make sure I did not have to rerun the whole thing if something went wrong. That was a good idea: some of the queries took 6 or 7 hours or more. With memories getting larger, may be tasks like this are better done in-core than using a database. 

1 comment:

  1. Yes indeed, and they are *cheap* -- both the systems that support them, and the memory dimms themselves. For example, this http://ark.intel.com/products/63697/Intel-Core-i7-3930K-Processor-12M-Cache-up-to-3_80-GHz chip from intel supports 64GB and only costs about $600. Also, as an extra bonus, the chip comes with 6 real cores

    ReplyDelete