Find Jobs
Hire Freelancers

help to solve a speed problem with Firebird 1.5

$30-5000 USD

Cancelled
Posted about 15 years ago

$30-5000 USD

Paid on delivery
a large Delphi 5 application opens about 25 queries onto a Firebird 1.5 database . IBObjects TIBOQuery objects (v. 4.5) are used to access the db. The more queries are opened, the slower the db access becomes. I did the following experiment: DoSomethingOnDB; // this action takes 1 sec OpenTable1; OpenTable2; OpenTable3; OpenTable4; OpenTable5; OpenTable6; OpenTable7; ... DoSomethingOnDB; // now the same action takes 20 sec !! The same action done against the db is now 20 times slower ! As we are performing exactly the same action, this should put away all guesses about indexes, PKs and (maybe) garbage collection: the response time (slow or fast) should be the same. The point here is that the db response times, after a while, degenerate to unacceptable values. I need help from someone with good experience in IBObjects and Firebird. He will work with me until the solution of the problem is found. Mainly he will remote connect to my PC using LogMeIn (as it would be hard to move the whole db). The solution could well be to expand the PC RAM or whatever.
Project ID: 3886854

About the project

2 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $128 USD for this job
User Avatar
See private message.
$85 USD in 3 days
4.7 (87 reviews)
7.2
7.2
User Avatar
See private message.
$170 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
Italy
5.0
509
Member since Feb 20, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.