[dba-VB] Why are my data Context Objects soooo sloooow

Mark Breen marklbreen at gmail.com
Thu Dec 3 08:34:16 CST 2009

Hello Shamil,

In VS2008, when I create a folder in app_Code, and then create a new Linq to
SQL Class is it assigned the extention of dbml, default name is

It is these classes that are sooo slooow to do anything with.  I timed the
time it takes to just click create, drop a table onto the design surface,
and then click save.  It is taking 4 minutes to do that, so when I needed 20
- 25 objects or so, I have to sit like a donkey and click for almost two

It still takes four minutes to open and edit one.

A PITA for sure.

If I open the class as a standalone file, I can operate with
instant performance, but it does not play well with the project/ solution.

I have to say, I wish I knew more about these data classes and how they
really should be used in real world applications.



2009/12/2 Shamil Salakhetdinov <shamil at smsconsulting.spb.ru>

> Hi Mark,
> <<<
> *Slow Data Contexts*
> >>>
> What do you mean by that? - editing and saving your DNN Data Context
> Objects
> source code in \AppCode subfolder?
> What do you mean by "Dbml"?
> <<<
> but have created about 20 module so far
> like this.
> >>>
> OK, I have also made 30+ DNN5.x custom modules properly packed etc. - all
> very similar to each other but to get the first one was a time-consuming
> issue. "Tired" from that. Need a break. Then I maybe will make some more...
> Thank you.
> --
> Shamil
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Breen
> Sent: Wednesday, December 02, 2009 4:39 PM
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: Re: [dba-VB] Why are my data Context Objects soooo sloooow
> Hello Shamil,
> Thank you for your detailed response.
> *Browsers*
> Some comments, I am actually using Chrome to View my work, but I am not
> doing any debugging, in the traditional sense, I code a few lines, click
> save and then view the results in Chrome, when I am not happy, I flick back
> to VS, change it and continue again.  So, it is true to say, I am not
> really
> debugging, just viewing.  However, I stopped using IE a few years ago, and
> since I switched to Chrome, it is the first thing I install on new
> machines.
>  With the exception of the MSDN site, it works perfect for me.
> *Slow Data Contexts*
> So can I assume that this slowness is simply to be accepted, it is either
> a)
> the way VS2008 usually performs, or b) the way VS2008 performs when data
> contexts are involved in a large project such as DNN.  I did not notice any
> difference when I copied the code from the wwwroot folder, so I hope that
> is
> not part of the problem.
> *DNN Development*
> Probably I am not doing real DNN custom programming, but I am currently
> building web user controls, and simply saving them, and then creating a
> module for DNN and including the web user control on that module.  I know
> this is not real DNN programming, but have created about 20 module so far
> like this.  DNN gives me, as a script kiddie type programmer, they ability
> to do a simple web app, but it manages the users and authentication,
> something that I could never program.
> IOW, with the exception of a few DNN hooks, I am doing simple programming,
> but throwing the results into DNN.
> *Free Lunch*
> I have to say I agree with you, there are limitations everywhere.  My
> appoach is always to keep it as simple as possible until I absolutely know
> that I need to make it more complex.
> Thanks,
> Mark
> <<< snip >>>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature
> database 4654 (20091202) __________
> The message was checked by ESET NOD32 Antivirus.
> http://www.esetnod32.ru
> _______________________________________________
> 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