Re: Table bloat in Linq-SQL

Andrus wrote:

You could partition your database into several contexts. Are you
sure this is actually an issue for you though? How much memory are
you seeing being used?

I'm sorry I was not clear.
The actual issue with that is that loading some of database tables
requires creating and loading additional assemblies at runtime.
Creating those assemblies requires some database access also.

Since all 500 tables are loaded always I'm afraid that creating
always all assemblies for all tables with database acess decreases
perfomance a lot.

So I'd prefer to create table objects only when required.

I'm looking for a way to modify database class to implement delayed
loading using table object getters or cache some data in isolated
storage or some other idea.

I think this is done to be able to create queries at runtime properly
from the expression trees. (otherwise the context will run into unknown
table references).

Why would you want to create these wrappers at runtime? Because that
way you can't program against them.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
.

Relevant Pages

  • Re: Table bloat in Linq-SQL
    ... The actual issue with that is that loading some of database tables requires ... creating and loading additional assemblies at runtime. ... using table object getters or cache some data in isolated storage or some ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Generating one table with a terabyte of data
    ... I didn't know we could split a database file group over multiple HDs. ... > Run perfmon counters to a log and analyze them after a bulk load. ... Another thing is to split the updates across file sets. ... >> loading of daily data in the fastest time. ...
    (microsoft.public.sqlserver.dts)
  • Re: general concerns regarding hacking of .NET assemblies
    ... >> CLI metadata to more or less random names, and optionally encrypting ... >> passwords used to access remote data, like a database server). ... >> Of course the password is encrypted in the file, but once the hacker finds ... > in .Net to sign your assemblies with a strong name, ...
    (microsoft.public.dotnet.security)
  • SQLClientPermission problem
    ... The database is on Machine 1. ... Both machines have SQL Server 2005 Express installed. ... assemblies on my local intranet signed with my strong name. ...
    (microsoft.public.dotnet.security)
  • Re: "top" consumes 25% cpu time
    ... Actually it's a webserver - what has gotten slow is the page loading ... On my local test machine with local database (a ...
    (alt.os.linux.suse)