[firebird-support] Slow Database

2011-11-10 Thread ck1625
Hi, I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the

Re: [firebird-support] Slow Database

2011-11-10 Thread Thomas Steinmaurer
I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for ever. At the

[firebird-support] Firebird ODBC driver: connection to an embedded server by using security2.fdb

2011-11-10 Thread patrick_marten
Hello, how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb? Is there any reason, why the security2.fdb is being ignored in that case at least by default? That way the ODBC connection can only be created with SYSDBA as user and there is no way to

[firebird-support] Re: Firebird ODBC driver: connection to an embedded server by using security2.fdb

2011-11-10 Thread patrick_marten
Thanks for your reply, creation of a ODBC connection to an embedded server works with SYSDBA only, is that correct? I was not able to create one with another user. If that's not correct: what can be the reason for the problem I have when trying to create a connection with a different user. If

Re: [firebird-support] Slow Database

2011-11-10 Thread Alexey Kovyazin
Hello, I have a website with PHP and a Firebird database. It looks like the Firebird database becomes very slow and I don't know, how to find where and why. My database is 15GB, the biggest table has about 30 million records. Right now I try to create the statistics, but it takes for