RE: [firebird-support] Firebird database executing DML queries very slowly.

2019-01-30 Thread 'Joje' j...@codework-solutions.com [firebird-support]
help. :) From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Tuesday, January 29, 2019 17:21 To: firebird-support@yahoogroups.com Subject: ODP: [firebird-support] Firebird database executing DML queries very slowly. Hi Is this from problematic

ODP: [firebird-support] Firebird database executing DML queries very slowly.

2019-01-29 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi Is this from problematic time with connected clients? If yes than i do no see problems. You must provide more details about issue. What exact comand is slow? What are the query plan and query sats? Did you tested HDD isues? … Regards, Karol Bieniaszewski

RE: [firebird-support] Firebird database executing DML queries very slowly.

2019-01-28 Thread 'Joje' j...@codework-solutions.com [firebird-support]
-support@yahoogroups.com Subject: ODP: [firebird-support] Firebird database executing DML queries very slowly. Hi. When you gain slowdows Run gstat -h and put here results. Problem probably is because of some long running transaction. Regards, Karol Bieniaszewski

RE: [firebird-support] Firebird database executing DML queries very slowly.

2019-01-26 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Thanks, I will try this command on customer end will upload the results. From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Friday, January 25, 2019 20:32 To: firebird-support@yahoogroups.com Subject: ODP: [firebird-support] Firebird database executing

ODP: [firebird-support] Firebird database executing DML queries very slowly.

2019-01-25 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi. When you gain slowdows Run gstat -h and put here results. Problem probably is because of some long running transaction. Regards, Karol Bieniaszewski

[firebird-support] Firebird database executing DML queries very slowly.

2019-01-24 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Hello, I am facing an issue on my client end where Firebird database is very slow in executing DML queries. I ran the customer database on my machine, it was working smoothly without any lag. This same database copied on customer machine gets very slow in executing DML queries. I replaced the

RE: [firebird-support] Firebird database corrupt with wrong page type error on table

2017-12-21 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
http://www.ibphoenix.com/resources/documents/how_to/doc_5 Regards Paul -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 21 December 2017 13:14 To: firebird-support@yahoogroups.com Subject: [firebird-support] Firebird

[firebird-support] Firebird database corrupt with wrong page type error on table

2017-12-21 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Hello everyone, During inserting data to a table I received an error on my application log "database file appears corrupt (DB Path) wrong page type page 232333 is of wrong type (expected 5, found 7)". On looking in FB log I got following : DEVMACHINE (Server) Thu Dec 21 16:45:23

Re: [firebird-support] Firebird Database to MYSQL Database conversion

2017-08-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.08.2017 12:43, vamsi sagiraju vamsi...@gmail.com [firebird-support] wrote: > I am alien to Firebird database, having no idea about it, But we have to > migrate it to > MySQL database(Have good idea about it). So could any one please let me know > how to > convert the Firebird database to MY

[firebird-support] Firebird Database to MYSQL Database conversion

2017-08-28 Thread vamsi sagiraju vamsi...@gmail.com [firebird-support]
Hi Team, Thanks for this opportunity to put my quiery here, Please let me know if this is not the right forum to raise this question. I am alien to Firebird database, having no idea about it, But we have to migrate it to MySQL database(Have good idea about it). So could any one please let me

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

2017-01-10 Thread Leandro Melo de Sales leandromsa...@gmail.com [firebird-support]
Dimitry, Thanks for your reply. The problem of backing up using gbak is that it is not possible to run incremental backups, right? By the way, i'm using nbackup 0-level per month and 1-level everyday, replacing the 1-level everyday by the new one. In this approach, if I run nbackup recover using

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

2017-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2017 16:30, Leandro Melo de Sales leandromsa...@gmail.com [firebird-support] wrote: > The database file size is huge as 56Gb. Is there any limitation of Firebird > as the size of > the database increase? No limitations at this level. 56Gb is quite small database. > any suggestion for

[firebird-support] Firebird database size is becoming huge (56Gb)

2017-01-10 Thread Leandro Melo de Sales leandromsa...@gmail.com [firebird-support]
Hi folks, My customer asked to create a solution for backing up his Firebird database. I have developed a solution using nbackup and send a tar bz2 file of the NBK to an S3 bucket in the Amazon. The database file size is huge as 56Gb. Is there any limitation of Firebird as the size of the

Re: [firebird-support] Firebird database keeps randomly locking up.

2016-03-29 Thread Michael Weissenbacher m...@dermichi.com [firebird-support]
On 24.03.2016 12:36, Richard Cooke rich...@alcoeng.co.uk [firebird-support] wrote: > > > > I have a problem with a Firebird database randomly locking up completely > for a period of time sometimes only a 30 seconds, sometimes 10 or 15 > minutes. I would suspect either a virus scanner or the

[firebird-support] Firebird database keeps randomly locking up.

2016-03-24 Thread Richard Cooke rich...@alcoeng.co.uk [firebird-support]
I have a problem with a Firebird database randomly locking up completely for a period of time sometimes only a 30 seconds, sometimes 10 or 15 minutes. Version is 2.1.7 Server is new running Windows Server 2012 R2. Only a smallish database with about 6 users. We never had any problems when

[firebird-support] Firebird database seems to influence multi user ability

2014-12-08 Thread Benny Schaich-Lebek bscha...@gmx.de [firebird-support]
Hi, I have been an interbase guy about fifteen years ago and loved to see it go open source. I used to work with Paul Beach (Hello, if you're here,Paul) Now I ran across a problem with firebird and tried to solve it. unfortunately half of the stuff is in the dark because the original software

Re: [firebird-support] Firebird database seems to influence multi user ability

2014-12-08 Thread marcus mar...@antiphasis.net [firebird-support]
On 08.12.2014 14:28, Benny Schaich-Lebek bscha...@gmx.de [firebird-support] wrote: Hi, I have been an interbase guy about fifteen years ago and loved to see it go open source. I used to work with Paul Beach (Hello, if you're here,Paul) Now I ran across a problem with firebird and

Re: [firebird-support] Firebird database seems to influence multi user ability

2014-12-08 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Benny, Look here http://ib-aid.com/en/articles/cannot-commit-index-or-how-to-pump-data-from-partially-restored-inconsistent-database/ I suggest to insert fake record with ORDERID = 4127, and then try to activate index. Regards, Alexey Kovyazin IBSurgeon Hi, I have been an interbase guy

[firebird-support] Firebird database

2013-05-28 Thread Marco Sucuzhañay
I found a database that weighs 640G, this basis consists of seven files. fdb ie datos_1.fdb datos_2.fdb datos_3.fdb datos_4.fdb datos_5.fdb datos_6.fdb datos_7.fdb as I can generate a backup of the database and how I can perform restore, thanks. [Non-text portions of this message have been

Re: [firebird-support] Firebird database

2013-05-28 Thread Alexey Kovyazin
Hi, So you found 640Gb of information. Is it related with recent leaks of account form BVI offshore companies? :) Regarding your questions - see gbak manual here http://www.firebirdsql.org/en/reference-manuals/ Regards, Alexey Kovyazin IBSurgeon I found a database that weighs 640G, this

[firebird-support] Firebird Database Backup 1.0 - versions supported

2012-11-27 Thread Benton Quest
Hi there, We have a Windows 2008 R2 64 bit server running Fb 1.5.6 32 bits classic, the database is around 2Gb. Would like to know if the Database Backup Software featured at IBPHOenix.com would be suitable to automate the database backup taks on this server. Link:

Re: [firebird-support] Firebird Database Backup 1.0 - versions supported

2012-11-27 Thread Norman Dunbar
Morning Jorge, We have a Windows 2008 R2 64 bit server running Fb 1.5.6 32 bits classic, the database is around 2Gb. Would like to know if the Database Backup Software featured at IBPHOenix.com would be suitable to automate the database backup taks on this server. Link:

[firebird-support] Firebird Database Woekbench Lite on Fedora Linux

2012-01-22 Thread Rohit
I installed Firebird on Fedora Linux. It installed FlameRobin GUI admin tool but it is quite limited. I want to install Database Workbench Lite from Upscene. Is it available for Linux and how to install it on Fedora? I am new to linux and firebird both. Rohit K. - [Non-text

Re: [firebird-support] Firebird Database Woekbench Lite on Fedora Linux

2012-01-22 Thread Helen Borrie
At 12:10 AM 23/01/2012, you wrote: I installed Firebird on Fedora Linux. It installed FlameRobin GUI admin tool but it is quite limited. I want to install Database Workbench Lite from Upscene. Is it available for Linux and how to install it on Fedora? I am new to linux and firebird both.

Re: [firebird-support] Firebird Database Woekbench Lite on Fedora Linux

2012-01-22 Thread Martijn Tonies
Hello Rohit, I installed Firebird on Fedora Linux. It installed FlameRobin GUI admin tool but it is quite limited. I want to install Database Workbench Lite from Upscene. Is it available for Linux and how to install it on Fedora? I am new to linux and firebird both. Database Workbench is not

[firebird-support] Firebird database comparison tool.

2011-10-15 Thread Thomas Clarke
Hello to all on the list. I am in the process of writing an application to update a program I have written that is coming out on the market shortly. The update will be delivered via the Internet. It is broken down into two major parts, i) update the exe file based on version numbers and ii)

[firebird-support] Firebird database comparison tool.

2011-10-15 Thread Thomas Clarke
Hello to all on the list. I am in the process of writing an application to update a program I have written that is coming out on the market shortly. The update will be delivered via the Internet. It is broken down into two major parts, i) update the exe file based on version numbers and ii)

[firebird-support] Firebird database is slow (?)

2011-09-25 Thread cruvadom
Hi all, I have a IBExpert client querying Firebird 2.5 server via tcp/ip over WAN. I'm making a simple query on the client side for an indexed table containing 2 columns and 4 rows (very small). overall time until data is shown is around 10 seconds. Prepare time is around 3 sec, execution is