Re: Abysmal performance of Scripting.Dictionary object on 2003 server

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

From: Michael D. Kersey (mdkersey_at_hal-pc.org)
Date: 05/28/04 

Date: Fri, 28 May 2004 00:20:47 -0500

Rodd Snook wrote:
> On Tue, 25 May 2004 09:13:33 -0500, Michael D. Kersey wrote:
<snipped>
>>BTW why use the Scripting.Dictionary object when you have Session and
>>Application variables available?
>
> What Ken said. Plus, I have a good many of them organised in hierarchies
> -- i.e. the values in some of the dictionary objects are other dictionary
> objects. To answer his original question, I probably have two objects with
> about 50 key/value pairs, but the values of each of these are themselves
> dictionary objects with about 5-10 key/value pairs. Before you say "Lord!
> That's an obscene amount.", I know it, and a lot of it could be cached at
> the application level (in some other kind of data structure, or maybe even
> as HTML), but the point is that the code performed acceptably on Win2k.
So a total of ~500-1000 items: not many, although we know nothing of
their content and, if they're built up and then discarded with each
page, that's a lot of overhead.

Are these dictionary objects running at low, medium(pooled) or high
(Isolated) protection level or running remotely?

Are they saved in the Session or Application objects or to files or a
database between page executions, or are they created and rebuilt with
each page execution?
>
> At the moment my preferred solution (apart from moving to another hosting
> provider who has Win2k) is to rewrite the whole thing in .NET, or maybe
> ASP/JScript or PHP (there, I said it!). Something with native support for
> sparse, associative arrays and regular expressions.
That would be Perl ( http://www.ActiveState.com/ ).

Relevant Pages

  • Re: finding a session that is running a sql
    ... crossing v$session and v$sqlarea for the statements hash value and no ... growing but can't match it to a session while it's growing. ... resulting trace files. ... as you are averaging almost 4K executions per minute. ...
    (comp.databases.oracle.server)
  • Re: finding a session that is running a sql
    ... I'm watching the executions in v$sqlarea ... growing but can't match it to a session while it's growing. ... what is the SQL statement that you are seeing ... cost based optimizer code. ...
    (comp.databases.oracle.server)
  • Re: finding a session that is running a sql
    ... I have a SQL that is consistently being executed 5.5 million times per ... I'm watching the executions in v$sqlarea growing ... but can't match it to a session while it's growing. ... HASH and SQL_ID as well as the SID ...
    (comp.databases.oracle.server)
  • finding a session that is running a sql
    ... I have a SQL that is consistently being executed 5.5 million times per ... I'm watching the executions in v$sqlarea ... growing but can't match it to a session while it's growing. ...
    (comp.databases.oracle.server)