We help IT Professionals succeed at work.

Interbase Server

Fredy992
Fredy992 asked
on
961 Views
Last Modified: 2013-12-09
I´m developing a client-server application using Interbase for my database. I made a test in which I installed the Interbase Server and my database in one place and left connected to the internet with a speed of 256k. Then I went to my house and also connected to the internet with the same speed. I connected ok to my database with no problems BUT, It´s tooo damn slow. I used IBCONSOLE to connect to it, when I try to open the data on a table that has only one record it took 25 seconds to open. It happens when I click on the Data tab. Even on my application it´s taking a long time to only do an open on my dataset. What´s causing it to be tooooooo slow ???? When Can I do to speed it Up ???
Comment
Watch Question

retired
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Ok then discard the Internet. I also tried a dedicated link and it also was too slow. Is Interbase a good Database for this kind of Client-server. Using a WAN (Wide Area Networ) instead of using a LAN (Local area network)
kacorretired

Commented:
If you use WAN then to be able optimal use the bandwidth of the data connection you have to minimize the number of rows (records) and columns (fields).

kacorretired

Commented:
sorry it was to late as I arrived home. I was tired and forgot the most important from the above sentence:

If you use WAN then to be able optimal use the bandwidth of the data connection you have to minimize the number of rows (records) and columns (fields)  ...   in your queries.

Janos
When I say Intenet i mean WAN environment!
Most of databases are bad in such environment because are not optimized for (SQL Server for example)
There was setting somewhere (in ibconfig may be) for setting larger packet size that helps. Using zeebedee also helps because it comress (and encrypt) traffic. Using FibPlus components (instead of IBX) also helps because is implemented casheing of metadata. Queryes for getting metadata information (field definitions and constraints) are big faktor in wan environment. Using TIBQuery like component instead of TIBDataSet like is better again for the lower overhead. And finally: Consider using three-tier technology for real-world WAN application! And do not use DCOM for that :)

Bojidar Alexandrov

Author

Commented:
Then the conclusion is: Interbase isn´t a good database for making this kind of application ? What database is better ? MySQL ? How would you do it if you had to do what I need ?Which is: Making an application connect to a database that´s located in another city. Thanx
You force me to repeat one thing three times!
Use three-tier technology! There are many for Delphy - midware for example
kacorretired

Commented:
Advantages of InterBase vs. MySQL?

Running InterBase is easier
InterBase is stable
InterBase needs no administrator
After crashing of server or network simply restart InterBase server
Backup InterBase is possible without disturbing the connected users
MySQL is better supported
The two products are near equal
idt
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
More - ZeeBeeDee can be used to compress data flow between client and server.
MySQL is a data storage bu yet it is not a database.

The real free Firebird/Interbase competitor is PostreSQL
idt

Commented:
Fredy,

kacor,  BAlexandrov, and I have made specific recommendations on interbase across thin connections, has any suggestion helped you in this endeavor?

Author

Commented:
What is a "three-tier technology!" and how do  I make a three-tier Application. Thanks guys

Commented:
It is also known as Milti-tier, or Application Server

For Borland Delphi it is what MIDAS whas designed for.
I do not know what language do You use, but try to look it's manuals, maybe there are some clues.

The main idea is that client is accessing App.Serv. with requests about documents, objects, et cetera, and it is App.S. that must convert those requests to SQL database, map object properties to SQL tables and columns, and so on.
idt

Commented:
It also has the benefit of providing an interface to the database that obfuscates the underlying structure and only presents the functionality that you wish to, similar to my suggestion of access only through stored procedures.

You could make a server daemon that uses a simple telnet protocol, that you use a simple set of a custom TEXT language.

The daemon could be already connected to the database, already prepared all of its queries and the upon the application connecting, perform a user validation that is indenpendant of the database.

The simple language could be optimized for thin networks, and always push the result sets, indicating last row, so that the communication does not involve the client fetching rows, that is the client asks for:all of row type x, and the daemon sends back row 1, row 2, row 3+lastind.

It can be a gas to develop such a system, we just completed such, and a true benefit, is that you can test each layer and the language using a telnet client.


"if the universe is expanding, why can't I find a parking spot?"
Daniel P.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.