RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

['Joje' j...@codework-solutions.com [firebird-support]]

Hi Karol,

 

I will look into how the delete query plan works on customer environment and 
will revert back. 

 

Thanks 

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: 18 April 2017 20:16
To: firebird-support@yahoogroups.com
Subject: Odp: [firebird-support] Deletion of rows from multiple tables takes a 
lot of time around 30mins

 

  

Hi,

For me 5 minutes looks also very long.
Look how delete query plan looks like

Regards,
Karol Bieniaszewski

- Reply message -
Od: "'Joje' j...@codework-solutions.com 
  [firebird-support]" 
mailto:firebird-support@yahoogroups.com> >
Do: mailto:firebird-support@yahoogroups.com> 
>
Temat: [firebird-support] Deletion of rows from multiple tables takes a lot of 
time around 30mins
Data: wt., kwi 18, 2017 08:17


  

Hello,

Today one of our customer complained that removing clients from application is 
taking a lot of time around 30-40mins.  So I looked into their database whose 
DB size is around 340MB and found that our DBA has a called deletion triggers 
in main table. Triggers will delete all the client information from related 
tables that 6 tables. Also, I checked the child tables from any additional 
triggers  but there were none. 

 

Now, when I copied this database to my development environment deletion works 
fast takes around 5 mins. I also rechecked with their older databases also 
whose size is around 1GB. Found no slowness during deletion.  

The question arises why this deletion process is taking so much of time at 
customer environment ?  

  /o>

Another thing I noticed was that FBServer was consuming 25% CPU usage during 
deletion.

 

 

Thanks in advance. 

 

With Regards,

Joje 

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

['Joje' j...@codework-solutions.com [firebird-support]]

Hi Sean,

 

I will look into it and will revert-back with additional details. 

 

Thanks.

 

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Sent: 18 April 2017 20:13
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Deletion of rows from multiple tables takes
a lot of time around 30mins

 

  



> Today one of our customer complained that removing clients from
> application is taking a lot of time around 30-40mins.  So I looked into
their
> database whose DB size is around 340MB and found that our DBA has a called
> deletion triggers in main table. Triggers will delete all the client
information
> from related tables that 6 tables. Also, I checked the child tables from
any
> additional triggers  but there were none.
> 
> Now, when I copied this database to my development environment deletion
> works fast takes around 5 mins. I also rechecked with their older
databases
> also whose size is around 1GB. Found no slowness during deletion.
> 
> The question arises why this deletion process is taking so much of time at
> customer environment ?

Let's start with:

- Is the server also a Windows domain controller?
- Have you compared performance of customer/your storage using Crystal Disk
Mark?
- What FB engine (Classic, SuperServer) are you running?
- What FB version are you running?
- If SuperServer what is the db page cache size?
- What is the db page size?

> Another thing I noticed was that FBServer was consuming 25% CPU usage
> during deletion.

That would not be surprising.

Sean

[firebird-support] Hint for maximaze FB performance, CPU Utilization - again.

[trsk...@yahoo.com [firebird-support]]

Hi guys,

I am using FB 3.02 in Superserver mode.

During my development - only single connection to FB Server, I do a lots of 
query. Each query took about 25-30 secs to complete, but CPU Utilization only 
used at around 16% on my six cores computer. 
On Ryzen 7 with 16 threads, I believe CPU utilization for FB is only 6%.

Are there any hints to set Firebird to use more cpu's power?

I think FB distributed works load based on number of cores. Each load divided 
equally on cores. So if there are 4 cores, each load/connection gets 1/4 cpu 
utilization. 

It will great if FB can distribute work load based on connection, first 
connection gets 100% cpu utilization, second connection, each one, get 50% cpu 
utilization, so on.

Btw, on SuperClassic FB 2.5 & no of connection +/- 100, I rarely saw cpu 
utilization raised up to 90% during heavy process. Mostly it was aroung 50-60% 
CPU Utilization.
 

 

 Thanks & regards,
 Anto

[firebird-support] Firebird 3.0 - local access works, but remote acess doesn't

[Roberto Carlos rc.1...@bol.com.br [firebird-support]]

I am using Firebird server on a Debian 9 stretch on a Virtual Box machine and 
FlameRobin client on another Windows 7 VM for testing.

There is no firewall activated.
I can access the database locally using isql-fb.

I have installed Firebird 3.0 via Debian oficial packages:
# apt-get install firebird3.0-server

And I have changed SYSDBA password:
# dpkg-reconfigure firebird3.0-server

And I have changed SYSDBA password via isql-fb:
-
https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-3-QuickStart.pdf
-
In this example, the “employee” example database is used,
because its alias is always present in a freshly installed Firebird setup:
#isql-fb
connect localhost:employee user sysdba password masterkey;

If you do this in isql, it should respond with:
#isql-fb
Database: localhost:employee, User: SYSDBA

Now alter the sysdba password:
#isql-fb
alter user sysdba set password 'Zis4_viZuna83YoYo';
-


# cat /etc/debian_version
9.0
# firebird -z (via apt-get install firebird3.0-server)
Firebird TCP/IP server version LI-V3.0.1.32609 Firebird 3.0

I have added the following to /etc/firebird/3.0/firebird.conf

DatabaseAccess = Full
RemoteAccess = True
UdfAccess = Full
AuthServer = Legacy_Auth, Srp, Win_Sspi
AuthClient = Legacy_Auth, Srp, Win_Sspi
UserManager = Legacy_UserManager, Srp
Providers = Remote,Engine12,Loopback
WireCrypt = Enabled
WireCompression = True
RemoteServicePort = 3050
ServerMode = Super





I am using Flamerobin 64 bits and Firebird Client 64 bits (fbclient.dll version 
3.0.2.32703) on the same FlameRobin's folder on another VM with Windows 7 
Profissional 64 bits:
---
About FlameRobin
---
FlameRobin 0.9.3 (git hash 5ece15b) Unicode (x64)
Database administration tool for Firebird RDBMS

This tool uses IBPP library version 2.5.2.1
wxWidgets library version 2.8.12
and Boost library version 1.54.0
---




I can ping and access Samba from Windows VM to Debian Linux VM, but I can't 
access Firebird 3.0:
---
Unhandled Error in FlameRobin
---
*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed

SQL Message : -902
can't format message 13:98 -- message file C:\Program Files\FlameRobin 
(x64)\firebird.msg not found

Engine Code: 335544721
Engine Message :
Unable to complete network request to host "192.168.100.100".
Failed to establish a connection.
---

What am I missing?

Odp: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

['liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]]

Hi,

For me 5 minutes looks also very long.
Look how delete query plan looks like

Regards,
Karol Bieniaszewski

- Reply message -
Od: "'Joje' j...@codework-solutions.com [firebird-support]" 

Do: 
Temat: [firebird-support] Deletion of rows from multiple tables takes a lot of 
time around 30mins
Data: wt., kwi 18, 2017 08:17
Hello, Today one of our customer complained that removing clients from 
application is taking a lot of time around 30-40mins.  So I looked into their 
database whose DB size is around 340MB and found that our DBA has a called 
deletion triggers in main table. Triggers will delete all the client 
information from related tables that 6 tables. Also, I checked the child tables 
from any additional triggers  but there were none.  Now, when I copied this 
database to my development environment deletion works fast takes around 5 mins. 
I also rechecked with their older databases also whose size is around 1GB. 
Found no slowness during deletion.  

The question arises why this deletion process is taking so much of time at 
customer environment ?   Another thing I noticed was that FBServer was 
consuming 25% CPU usage during deletion.  Thanks in advance.  With Regards,Joje 

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> Today one of our customer complained that removing clients from
> application is taking a lot of time around 30-40mins.  So I looked into their
> database whose DB size is around 340MB and found that our DBA has a called
> deletion triggers in main table. Triggers will delete all the client 
> information
> from related tables that 6 tables. Also, I checked the child tables from any
> additional triggers  but there were none.
> 
> Now, when I copied this database to my development environment deletion
> works fast takes around 5 mins. I also rechecked with their older databases
> also whose size is around 1GB. Found no slowness during deletion.
> 
> The question arises why this deletion process is taking so much of time at
> customer environment ?

Let's start with:

- Is the server also a Windows domain controller?
- Have you compared performance of customer/your storage using Crystal Disk 
Mark?
- What FB engine (Classic, SuperServer) are you running?
- What FB version are you running?
- If SuperServer what is the db page cache size?
- What is the db page size?


> Another thing I noticed was that FBServer was consuming 25% CPU usage
> during deletion.

That would not be surprising.


Sean

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

['Joje' j...@codework-solutions.com [firebird-support]]

Hi martin, 

 

Thanks for help but firebird database is in Windows server 2008 OS.  

 

 

 

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Sent: 18 April 2017 16:54
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Deletion of rows from multiple tables takes a
lot of time around 30mins

 

  

Hello Joje,

 

please check the file system. We had a similar issue with btrfs on OpenSuse
several months ago. After switching to ext4 everything went fine. Maybe it
was a problem with the file system's journaling option.

 

Regards

Martin

[firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

[Köditz, Martin martin.koed...@it-syn.de [firebird-support]]

Hello Joje,

please check the file system. We had a similar issue with btrfs on OpenSuse 
several months ago. After switching to ext4 everything went fine. Maybe it was 
a problem with the file system's journaling option.

Regards
Martin