Re: Creating many cursors, closing them, and c0000005
From: Tim Witort (trw7at_at_ixdot.netcomdotcom)
Date: 02/20/04
- Next message: Tim Witort: "Re: get picture from digital camera"
- Previous message: Thierry Nivelet: "Re: a name or an object reference"
- In reply to: Ook: "Re: Creating many cursors, closing them, and c0000005"
- Next in thread: Ook: "Re: Creating many cursors, closing them, and c0000005"
- Reply: Ook: "Re: Creating many cursors, closing them, and c0000005"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Feb 2004 18:05:30 GMT
Ook seemed to utter in news:#jpr8y79DHA.1648@tk2msftngp13.phx.gbl:
> I use CREATE CURSOR. The cursor has 3 fields, and at the most 20
> records. I populate it, massage it, and close it. No memos. This whole
> process takes a split second, and AFAIK none of them have ever been
> paged to disk, IE there is no physical disk presence. The reason I
> suspect this is causing the error is because that is the only change I
> made to the program. However, the c0000005 does not happen often enough
> for me to establish a pattern. In now happens once a week, where it
> never happened at all before.
>
> Win2000 Pro ( I thought it was server, but I was wrong). SP3 (I'm going
> to apply sp4 this weekend). PIII 1266MHz. ATI Rage xl pci (bleah -
> another stinkin' ATI video card). IMNSHO not the best of hardware.
> Blade enclosure.
>
> I haven't tried to reproduce it yet, I'm still watching and gathering
> information. The app only runs on this one box. One of my co-workers
> told me he had a similar problem, and he applied SP4 to Win2000, and
> the problem went away, so I'm going to do that tomorrow.
>
>
> "Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
> news:%23eM0qpz9DHA.2064@TK2MSFTNGP11.phx.gbl...
> Besides Dan's ideas / questions, is the cursor always the same
> structure? Do you create it with CREATE CURSOR or an SQL SELECT?
> (READWRITE option or do you use the DBF() "trick"?) What kind of fields
> are there in the cursor? (Any memos?) How big to the cursors get? (A
> couple hundred records or a couple hundred thousand? In other words are
> they likely to alway be in memory or are they paged out to disk?)
>
> Can you provide a "simple" sample program that causes this, or does it
> only happen in your more complex program? (It may be something else
> you're doing!)
>
> What OS are you running under? What kind of configuration? (CPU, speed,
> memory size, disk type, etc.) Does it only happen on one system, or
> have you seen it happen on multiple setups?
>
> Rick
>
> "Ook" <outlookexpress@nospam@embertsdotcom> wrote in message
> news:eFioscx9DHA.3452@TK2MSFTNGP09.phx.gbl...
>> I have an app that creates a cursor, populates it, massages it, and
>> closes it. This happens several times a minute, sometimes several
>> times a second. The app runs 24/7. Ever since I started doing this,
>> I'm getting c0000005. The line of code is the read events line, which
>> is less then helpfull.
>>
>> Any thoughts on creating cursors and closing them a couple thousand
>> times, and if this might affect system stability?
That is a very small amount of data to create a cursor
for (at most 60 values). Are there actions in the "massaging"
phase of your logic that require these values to be in
a cursor rather than in, say, an array or memory variables?
Those might be easier on memory management.
-- TRW
_______________________________________
My e-mail: t r w 7
@ i x . n e t c o m . c o m
_______________________________________
- Next message: Tim Witort: "Re: get picture from digital camera"
- Previous message: Thierry Nivelet: "Re: a name or an object reference"
- In reply to: Ook: "Re: Creating many cursors, closing them, and c0000005"
- Next in thread: Ook: "Re: Creating many cursors, closing them, and c0000005"
- Reply: Ook: "Re: Creating many cursors, closing them, and c0000005"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
