INTERBASE

[Dennis Hassell]

I assume you are using some 4GL component - which one? QUICK or QTP?

I don't have experience with Interbase, but I have run into locking
issues with Allbase. Are you doing row-level locking? (Does Interbase
have row-level locking?) If so, that takes more resources, both in the
recording of the locks (out of room), and in the overhead (each access
to that table must look up ALL locks on that table to see if that
particular row is locked). Also, locks are not released until the
COMMIT, so maybe you will need to commit more often. 

I am just guessing here, but the additional space allocated for locks
might slow things down due to looking through a larger area.

If you don't need row-level locking, don't use it. Table-level locking
can work much more efficiently as long as the locks are not held for a
long time, i.e. a few seconds or less. In Allbase, the row-level locking
ability is set at the table level, and Powerhouse will just do whatever
is set.

Hope this helps.

Dennis Hassell
Dennis Hassell and Associates
(941) 746-4919
(941) 224-3981 - cell



-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
On Behalf Of Jeff Hoffman
Sent: Tuesday, May 06, 2003 10:39 AM
To: powerh-l@lists.swau.edu
Subject: INTERBASE


Hi

My old site is having trouble:

Fatal lock manager - lock manager out of room.
this is not the exact message but is close.

They increased the number of locks by a huge amount and the system is
running, but verrrry slowly.

Can anybody out there suggest something to improve performance?

Sorry I do not have much info, but your suggestions would be
appreciated.

Thanks

Jeff
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+-+-+
+ Jeff Hoffman                          + e-mail:
wonicon@optushome.com.au  +
+ Director                              +
+
+ WoniCon Pty Ltd   (ABN 93 083 502 630)+                          ,-_|\
+
+ 21 Prices Circuit                     + voice: +61 2 9542 1527  /
\   +
+ Woronora    NSW     2232              +
\_,-._*   +
+ AUSTRALIA                             + mobile: 040 790 3929         v
+
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+-+-
+
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.