You can either change the table names so they are the same as the table you
want to merge into, and then so the merge or create a new table with relations
that have the tables created by the stored proc calls become child rows. You
then put column expressions referring to the child table column a
Why not just use a UNION in your stored procedure and just get a single
result set back?
HTH,
Matt
-Original Message-
From: adonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:26 AM
To: [EMAIL PROTECTED]
I have created a stored procedure in Sql Server which uses a cursor
You can merge tables in this way, even if they do not have the same schema
structure. I have done this when the data is scattered across multiple
tables and the join would have been painful. There are a couple of things
to keep in mind:
1. Merge is going to match up the table by table name. Sin
I may be misstating this so if I am please correct me.
There are 2 levels that objects are kept at in regards to garbage
collection. The actual name of these "levels" evades me at this moment so I
will just refer to them as level 1 and 2. With that said, the first level is
where all objects are at
This article might help.
Displaying Two DataTables In One DataGrid
http://www.dotnetbips.com/displayarticle.aspx?id=94
-Original Message-
From: adonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 11:26 AM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] Merging Tables in a Dat
Thanks to everyone for the replies. I've done
everything short of calling the garbage collector
which has been suggested against both in print and
verbally. As for the SQL solution Russ suggest below,
I think my collection of SQL stored procs that gets
called to create my reports its more complic
Are you looking at the process virtual memory size or the working set
size? These two will give quite a different picture of what your
process is doing. (It's also sometimes a less than exact science
interpreting this stuff, since measuring a process's memory use is not
always that clear cut - if
> My first question would be for what purpose?
I want a second AppDomain because I want a fresh copy of each of my
singletons. These singletons hold cached data that changes slowly. Note
that I do *not* want to update the cached data in the first AppDomain.
> Changing the Web Config file for an
I wrote 2 processes running on the same machine. Each process
communicates with each other by sending 200 messages with a size
of 1024 bytes. I got the following result for each IPC methods:
TCP Socket: 10ms
Remoting: 100ms (TCP channel, binary format serialization)
System.Messaging: 40ms (Expre
My experiment:
1) 2 AppDomains within one process:
AppDomain A sends AppDomain B 100 messages via Remoting or Socket
AppDomain B sends AppDomain A 100 messages via Remoting or Socket
2) 2 Processes:
Process A send Process B 100 messages via Remoting or Socket
Process B send Process A 1
Hello
This is my first post and also my first foray into the wonderful world
of .NET Remoting.
I apologise if it's a little long.
I have been experimenting with .NET remoting particularly in the area of
authentication.
I have hosted a simple component in IIS 6 running on Windows 2003 Server
and s
The term for these 'levels' is generations. In fact there are 3
generations, numbered 0, 1, and 2. Objects in generation zero are those
which were allocated after the most recent garbage collection to have
completed.
What you say is true - objects that are in generation 0 that are still
in use a
> My first question would be for what purpose?
My application caches data in a singleton. Eventually this data goes out of
date. I need a second AppDomain in order to cache fresh data in the
singleton. Note that I do *NOT* want to update the first AppDomains's
cache. I just want it to die a n
Did you send those messages concurrently, or one after the other?
If you care about scalability, simple sequential tests aren't going to
tell you much. You'll want to construct a test where you measure how
the response time varies as you increase the load, preferably from a
number of clients.
Bu
Courtney,
This issue has been discussed previously and, as Ian pointed out, the likely
problem is not that the runtime holds a lot of live objects, but that free
memory is not returned to the underlying OS.
You might want to use the following trick:
public class MemoryManagement
15 matches
Mail list logo