Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The Expand / Collapse
Author
Message
Posted Wednesday, November 15, 2006 7:40 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 4:10 PM
Points: 241, Visits: 74
255 is usually a significant number in this industry of ours. I wonder where that fits into the issue you just mentioned.


Regards,

Steve

Life without beer is no life at all

All beer is good, some beers are just better than others

Post #323315
Posted Thursday, November 16, 2006 5:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 11, 2014 8:12 AM
Points: 55, Visits: 228
I know.  weird.
Post #323376
Posted Saturday, October 20, 2007 7:02 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:05 PM
Points: 36,716, Visits: 31,166
Actually, just had cause to revisit this particular thread...

... and it just dawned on me that tests in the article are not measuring the performance of each method... the tests are measuring how well each method runs a loop which has nothing to do with transferring data to a file. If you want a real test, build a table with desired number of rows (100k for example) and then simply select from that table using each method. The results will be drastically different.

Here's how to build a 100k row table of numbers in an eye-blink...
 SELECT TOP 100000
IDENTITY(INT,1,1) AS N
INTO dbo.Numbers
FROM Master.dbo.SysColumns sc1,
Master.dbo.SysColumns sc2

And, yeah... where is the test for BCP?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #413130
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse