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
Posting on local data vs posting on server data
Re: Posting on local data vs posting on server data
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
Not the case and sure about it
Re: Posting on local data vs posting on server data
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.
Without this, it is impossible to find the answer.
Re: Posting on local data vs posting on server data
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)
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
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
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.