Unexpected behaviour of methods when executed.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rajashekar (rajasekhark_at_bsil.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 22:00:05 +0530

Hi All

I have referenced a COM dll in my .NET assembly. The DLL has functions that
interact with the database. When I execute functions that interact with the
database, the insertions into database are unpredictable. Some time the
functions insert immediately, sometimes I need to reset IIS to see the
inserted records. I tried explicitly collecting garbage(GC.Collect()). After
that the insertion in few functions are done immediately but some functions
still keep the queries in queue and execute it when there is enough memory.

Is there any way we can explicitly specify the memory for the function
execution?

Regards
Shekhar

Relevant Pages

  • Re: Cross-database execution permissions with certificates and sch
    ... activated user cannot access objects in other schemas in this database. ... injection is defended against, however, the threat exists anywhere EXECUTE ... CREATE USER dispatcher ... the certificate is a trusted authenticator because you granted AUTHENTICATE ...
    (microsoft.public.sqlserver.security)
  • Re: LogonUser / CreateProcessAsUser - Behaves differently from different calling applications
    ... >CreateProcessAsUser to execute the command. ... Calling the DLL from another win32 ... > * This object maintains data for the Authentication and Process ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)
  • Re: SQLCE performance from .NET CF v2.0
    ... Please remember when bulk inserting is being executed against SQL CE, ... > local database functionality. ... > database technology and I am considering switching to SQLCE at the same ... > execute the prepared statement again. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: CFS: some bad numbers with Java/database threading
    ... execute multiple queries on the same data, ... workload is "pathological". ... lock-less algorithms (like variations on optimistic locking) because ... if the locking is implemented using database ...
    (Linux-Kernel)