Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Wed Apr 30 13:28:58 CDT 2008
Thank you, John, You have a very good PC, lucky man! :) As I wrote already I (I'm sorry) did post incorrect query - I wanted to run this one: SELECT RowNum, PKID from ( select Cast(ROW_NUMBER() over (ORDER BY [PKID]) as int) as RowNum, PKID from [Names]) s where (s.RowNum % 1000) = 1 union all Select NULL as RowNum, Max(PKID) as PKID from [Names] It will also return 96K rows for your huge table, but it's expected (here) it will get first results instantly, and it will finish within just several (3?) seconds... Please prove am I wrong with that bright above expectations on the execution time of the fixed version of the query?... Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, April 30, 2008 9:41 PM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] vb.net - Updates 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 > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com