[dba-VB] vb.net - Updates

jwcolby jwcolby at colbyconsulting.com
Wed Apr 30 12:41:16 CDT 2008


Shamil,

It took Stonehenge (2.8ghz AMD x2, 4 gigs Ram, Windows x32, SQL Server 
x32) 13:51 to pull 96,417 rows for the result set.

John W. Colby
www.ColbyConsulting.com


Shamil Salakhetdinov wrote:
> Hi John,
> 
> May I ask you to run this query (e.g. in MS SQL Management Studio) against
> your huge db table?
> 
> --- cut here ---
> 
> SELECT RowNum, PKID from  ( select  
> 	Cast(ROW_NUMBER() over (ORDER BY [PKID]) as int) as RowNum, 
> 	PKID, OWNERNAME, FName, MName, LName, NamePrefix, 
>     NameSuffix, Gender from [Names]) s  
> 	where (s.RowNum % 1000) = 1 
> union all
> Select NULL as RowNum, Max(PKID) as PKID from [Names]
> 
> --- cut here ---
> 
> M.B. [Names] have to be substituted with the name of your table - what is it
> BTW?
> 
> This query returns PKID of every 1000th row sorted by PKID + MAX(PKID)....
> 
> I'm curious to know how much time approx. this query will take to execute...
> 
> Thank you.
> 
> --
> Shamil
> 
> P.S. BTW, here is a useful for your case article on multi-threading
> (practical solution) with good introduction -
> http://www.dotnetjunkies.com/Tutorial/D7E688B8-0BDD-4D44-9A0F-4CD26FB35F51.d
> cik 
> 
> Sorry, I can't react promptly on your messages in this discussion thread: a
> lot of custom work here, long weekends and our time zones difference but I
> do continue to work in this direction and if I get some useful  results I
> will post them here...
> 
> P.P.S. This book could be also useful:
> 
> C# Threading Handbook 
> by Tobin Titus et al.   
> 
> ISBN:1861008295 
> 
> APress, LLC C 2004 (288 pages) 
> 
> This book addresses the fundamental units of Windows and .NET
> programming-threads. Coverage includes how .NET applications are executed,
> the life cycle of a thread in .NET, how the .NET Framework uses threads, and
> more.
> 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
> 



More information about the dba-VB mailing list