SQL Batch Imports Dropped from 27 Hours to 12 Hours - a 15 Hour Reduction
ASL Marketing’s business is database marketing with millions of records under management that advertising agencies and vendors alike put to use. This database is constantly being appended to and updated to reflect the most current behavioral and demographic data, which is an absolute must for their clients who need immediate access to the most current data at all times.
Records were ballooning to the point that the monthly import to the master database exceeded 150 million records and took 27 hours to run the batch job across their SQL servers. Other databases like their college record database needed to be updated once a week and would take 17 hours to complete. As a result, access to the most current data was being delayed by a full day and sometimes two.
With data under management exploding, the IT staff was managing to a flat budget and needed to find ways to improve performance without buying expensive new hardware.
"Typically, IT professionals respond to application performance issues by reactively buying more hardware. Without the luxury of a padded budget, we needed to find a way to improve performance on the hardware infrastructure we already have," said Ralph Ortiz, IT Manager, ASL Marketing.
"I was very doubtful that V-locity could improve my I/O performance through a software-only solution. But with nothing to lose, we evaluated V-locity on our SQL servers and were amazed to see that, literally overnight, we doubled performance and cut our SQL batch job times in half," said Ortiz.
Read the full story
Offered Free by: Condusiv Technologies
See All Resources from: Condusiv Technologies