troubleshooting Question

Delphi client/server application - performance issue

Avatar of SciFiFreak
SciFiFreak asked on
Delphi
8 Comments1 Solution717 ViewsLast Modified:
Hello Experts,

I developed a client/server application that runs very well inside an intranet. However, it performs poorly when used over the internet. Since the database I currently use is DBISAM I am considering porting the application to Oracle. Still, I am not sure if replacing the database server will provide any benefit.

Most of the performance issues are related to my implementation. For example:

table.first;
while not table.eof do begin
  // some code
  table.next;
end;

Loops like that are really slow over the internet. Does anyone know if Oracle would provide a better performance in such cases.

Thanks in advance!
ASKER CERTIFIED SOLUTION
Voodooman

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros