Page 1 of 1

Posting on local data vs posting on server data

Posted: Wed 14 Dec 2016 07:16
by Khatchig
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

Re: Posting on local data vs posting on server data

Posted: Wed 14 Dec 2016 07:55
by sugi
I think, your server has more powerful hardware than your computer, that's why it finished first.

Re: Posting on local data vs posting on server data

Posted: Wed 14 Dec 2016 08:06
by Khatchig
Not the case and sure about it

Re: Posting on local data vs posting on server data

Posted: Thu 15 Dec 2016 02:11
by sugi
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.

Re: Posting on local data vs posting on server data

Posted: Thu 15 Dec 2016 07:28
by Khatchig
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)

Re: Posting on local data vs posting on server data

Posted: Thu 15 Dec 2016 07:31
by Khatchig
Note that the same testing using firedac with the same set up is giving more realitic figures(locally faster than on network)

Re: Posting on local data vs posting on server data

Posted: Thu 15 Dec 2016 09:23
by ViktorV
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.