Solved

ISAPI and BDE over DBF

Posted on 2001-06-06
7
294 Views
Last Modified: 2013-11-23
Hi all, here it is:

There's a NT4 SP6a, IIS4 machine, dual P3. On that, some legacy DBF tables are presented via Web interface using ISAPI DLL's written in D3 and running over BDE 4.51. The ISAPI DLL's are using CachedConnections=true currently with a pool of 50 connections.
It used to work, but lately we had to increase the pool size due to higher requests volume and increased query response time (prev pool size was around 10).
Now after some time (about 2 hours after full restart), the whole thing locks. After restarting IIS, the static pages are OK, the dynamic ones are failing and other BDE apps are failing, too, meaning that BDE got sick. The only way to restore operation is full server restart.

Any suggestions? Anyone saw that before?

0
Comment
Question by:fva
7 Comments
 

Expert Comment

by:BuD
Comment Utility
Be sure to use the session component before opening any tables.
Verify that all tables are closed correctly.
0
 
LVL 4

Author Comment

by:fva
Comment Utility
Hi, BuD, welcome to ExEx.

Sorry, I have to reject your proposed answer. We DO use TSessions and closing the tables is not an option because that's why we are using CachedConnections in the first place: to reduce latency on new requests. Closing the tables would nullify that.

Thank you for trying, but your opinion would have fit better as a comment, not as an answer. Seeing that you are new around, I do not take it hard and neither should you my rejection. Usually, answers are posted _only_ where you are pretty sure that the proposed answer _will_ solve the problem. Unless that holds, you'd be better off posting comments. It's a custom around here.

Yours,
F.
0
 
LVL 17

Expert Comment

by:geobul
Comment Utility
Hi fva,
I'm sorry for my stupid question but anyway:
What pool do you have in mind? Is it MaxConnections property or something else? Where in the code are you setting this value?

Regards, Geo
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 4

Author Comment

by:fva
Comment Utility
Yes, it's MaxConnections and it's set in the main project file, right at the top (almost before anything else or right before anything else).

F.
0
 
LVL 1

Accepted Solution

by:
MaxSCZ earned 150 total points
Comment Utility
hi,
May be Insufficient memory error upgrade your BDE version to 5.01
bye Max
Look at this from Borland :

Area: paradox and dbase
Reference Number: 36 (Published: 03/25/98)

Status: Fixed
Sub Area: Database

Date Reported: 11/06/97

Severity: Infrequently Encountered

Type: Basic Functionality Failure

Problem:

Opening 8 TDatabases all connected to 8 different
TSessions results in Insufficient memory error.
Opening the TDatabases without their own  
sessions works fine.



0
 
LVL 4

Author Comment

by:fva
Comment Utility
Thanks, I'll try that and I'll get back to you. (hope it won't break the server; in that case it'll take a litle longer to hear about me :) )

F.
0
 
LVL 4

Author Comment

by:fva
Comment Utility
Well, it seems that no-one is adding any comment to this (normal, due to my comment above), so I'll have to close it, even if I'm no smarter after this Q.

MaxSCZ, we did upgrade BDE, but at the same time we made extensive changes in the inner workings of the DLL, making it to respond faster. Now it works somehow (not great, only somehow :) ). Therefore I cannot say if the upgrade really helped (in the first place it broke the whole thing) or if the rewrite itself was helpful.
I'm going to give you the points anyway; thank you.

In the long run, we are going to dump BDE and choose another way to access data (together with a data platform migration to a better DBMS).

Thanks,
F.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now