Re: Table bloat in Linq-SQL

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.

Andrus.


.

Relevant Pages

  • Re: Table bloat in Linq-SQL
    ... The actual issue with that is that loading some of database tables ... Creating those assemblies requires some database access also. ... My .NET blog: http://weblogs.asp.net/fbouma ...
    (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)