title: What's the best way to export huge Magento catalogs
body: <p>I am reading a ton of docs about Magento's API, Magento's Models and Direct SQL calls. As I was reading that, the first conclusion is that direct sql calls would be very faster but I must take a special care at security, and the use of models make the development faster and easier but in the other hand, it loses performance manipulating huge catalogs.</p>
  
  <p>I will have to deal with a shop with around 50k of products &amp; heavy traffic, and I must export them to another server with category hierarchy, sku, description, image, product_name, url_path once and after it get only the updated ones once a hour. The best approach would be with direct sql calls, but will it be a suicide to make it with models? And do you think that integrate it with the SOAP API will be another suicide, and I should make it in a separate PHP to do this?</p>
  
  <p>Super thanks in advance, I am very lost at this, and sorry for my bad English
  Vinicius</p>