Posting on local data vs posting on server data

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Khatchig
Posts: 6
Joined: Wed 30 Nov 2016 09:54

Posting on local data vs posting on server data

Post by Khatchig » Wed 14 Dec 2016 07:16

Hi, i am using ibdac with firebird. While using local data editing of 120,000 records is taking about an hour. On the other side using the same data on network and the same procedure is taking half an hour. How do you explain this wierd behavior. Is there a property of a component i should change? Any idea?
Thank you in advance

sugi
Posts: 43
Joined: Wed 07 Dec 2016 02:05

Re: Posting on local data vs posting on server data

Post by sugi » Wed 14 Dec 2016 07:55

I think, your server has more powerful hardware than your computer, that's why it finished first.

Khatchig
Posts: 6
Joined: Wed 30 Nov 2016 09:54

Re: Posting on local data vs posting on server data

Post by Khatchig » Wed 14 Dec 2016 08:06

Not the case and sure about it

sugi
Posts: 43
Joined: Wed 07 Dec 2016 02:05

Re: Posting on local data vs posting on server data

Post by sugi » Thu 15 Dec 2016 02:11

You have to supply more detail info about your computer & server hardware & OS, Firebird version & Firebird mode (SS,SC, CS) on your computer & server.

Without this, it is impossible to find the answer.

Khatchig
Posts: 6
Joined: Wed 30 Nov 2016 09:54

Re: Posting on local data vs posting on server data

Post by Khatchig » Thu 15 Dec 2016 07:28

Firebird version 3.0.1 embeded
Local PC core i5 3.10GHz 4GB RAM
Data located on a PC with core i3 2.9 GHz 4GB RAM

Using the above set up the posting is faster than connecting to the data locally using the same firebird version (and the above local pc)

Khatchig
Posts: 6
Joined: Wed 30 Nov 2016 09:54

Re: Posting on local data vs posting on server data

Post by Khatchig » Thu 15 Dec 2016 07:31

Note that the same testing using firedac with the same set up is giving more realitic figures(locally faster than on network)

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Posting on local data vs posting on server data

Post by ViktorV » Thu 15 Dec 2016 09:23

In order to get a detailed answer, please compose a small sample demonstrating the described behavior and send it using the contact form https://www.devart.com/company/contactform.html including scripts for creating database objects.

Post Reply