Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Any faster? :D

Author  Topic 

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-09-09 : 05:39:18
Not too shabby I must say...anyone better out there? 2.2GB in 5 mins and counting
(this is ftp from our biggest db-competitor btw, nothing internal going on)



- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/

Kristen
Test

22859 Posts

Posted - 2011-09-09 : 06:07:00
"this is ftp from our biggest db-competitor"

I suppose the faster you download your competitors databases the less chance you have of getting caught?

Bit like my Dad used to tell me when teaching me to drive: "The faster you go across a cross-roads the less chance you have of hitting anything"
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-09-09 : 06:16:41
The transfer actually peaked at close to 17 MB/sec just now...insane!

"Unfortunately" I'm on a data warehouse project that has oracle as the bottom layer. Haven't worked a whole lot with it yet but the fact that I have to work with Enterprise Linux in the dev environment makes me shiver!

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-09-09 : 06:27:59
... you'll probably find that the Requirements Document states you have to use MySQL as the middle-man in a moment ...
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-09-09 : 06:28:58
24,2GB in 59m 20s from the internet to my laptop. I'm amazed.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-09-09 : 11:05:55
"The faster you go across a cross-roads the less chance you have of hitting anything"

I like it!
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-09-09 : 12:47:27
quote:
Originally posted by russell

"The faster you go across a cross-roads the less chance you have of hitting anything"

I like it!



Don't try this at home children
Go to Top of Page
   

- Advertisement -