On Mon, Oct 1, 2012 at 7:27 AM, mikey <[email protected]> wrote: > Sorry I was away from my office and was not able to reply > I used microsoft Just in time way data loading to fill my datagridvie. with > the data. Here is the link > > http://msdn.microsoft.com/en-us/library/ms171624.aspx > > Can you please let me know what is going on. If you like to see more code, I > dont mind sending you the classes for the search. > > database table contains 20-30 millions of records, partioned, well-idexed. > SQL Server takes 1-2 seconds to display results. ------------------
Don't drop SPROCS and regen them from your VB code unless this is an upgrade to a system in the field or a new install. Learn to pass in the params that you want to use in the where clause. >> table.Load(dr) // this is taking too long So replace it. It looks all kinds of M$ tweaked for the receiving container and not optimized to accept data from a datareader. look here <http://www.startvbdotnet.com/ado/sqlserver.aspx> Just comment out all those messageboxes. You then return the datatable, dt, from your SQLQuery method so it is reusable. You pass to that method the loaded SQLConn object. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
