Re: [firebird-support] Question about few Firebird details

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi Karol,

44. This option turn off individual savepoints. Our tests proof that 
gives slight  increase in case of massive inserts or updates. Use it 
with caution, since the rollback will be forced (through TIP), so if you 
insert less than 50k records, there could be difference with and without 
NO_AUTO_UNDO  - Firebird will be not able to transform rollback into 
commit with savepoints. If you insert more than 50k records (actually 
50-60k, it depends on memory, not exact ##, if I remember correctly), 
rollback will be done through TIP anyway.


45. Try it with table like
CREATE TABLE T1(i1 integer not null primary key, iSort integer, 
BIGSTARTING VarchaR(2000));
insert there 10 mln records and do 2 queries as in the example. It will 
take 10 mins, and and you'll see the difference by yourself.


Regards,
Alexey Kovyazin
IBSurgeon



Hi,
https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/
i have few questions:
44. Use NO_AUTO_UNDO - what happend when i do rollback? I do not 
understand what really do this option..

30. Use derived tables to optimize SELECT with ORDER BY/GROUP BY -
SELECT T.FIELD_KEY, T.FIELD1, T.FIELD2, ... T.FIELD_N
FROM (SELECT FIELD_KEY FROM T ORDER BY FIELD2) T2
JOIN T ON T.FIELD_KEY = T2.FIELD_KEY
why this can be faster then?
SELECT FIELD_KEY, FIELD1, FIELD2, ... FIELD_N
FROM T
ORDER BY FIELD2
Firebird sort whole resultset of "sorted key - Field2" or do different 
work?

I see in FB3 plan sort width and it looks like not true but?
regards,
Karol Bieniaszewski

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.05.2016 22:08, Bunth Tamás btom...@gmail.com [firebird-support] wrote:
> It seems to me that firebird looks for the user name in the security2.fdb
> file, which shouldn't be used in an embedded server. What am I missing?

   There is no embedded server on Linux. You are trying to use Classic Server.

-- 
   WBR, SD.

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

[Bunth Tamás btom...@gmail.com [firebird-support]]

On 23 May 2016 at 21:01, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]  wrote

> >You don't need password, but user name must be.
>
When I add "SYSDBA" as a user name to the spb of isc_service_attach, I got
the following error:

*I/O error during "open" operation for file
"/usr/local/firebird/security2.fdb"
*Error while trying to open file
*No such file or directory
caused by
'isc_service_attach'

It seems to me that firebird looks for the user name in the security2.fdb
file, which shouldn't be used in an embedded server. What am I missing?

Re: [firebird-support] Question about few Firebird details

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.05.2016 21:05, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] 
wrote:
> 44. Use NO_AUTO_UNDO - what happend when i do rollback?

   You will get hard rollback, frozen OAT counter and unavoidable run of sweep.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Question about few Firebird details

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

Hi,
 
https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/
i have few questions:
44. Use NO_AUTO_UNDO - what happend when i do rollback? I do not understand 
what really do this option..
30. Use derived tables to optimize SELECT with ORDER BY/GROUP BY - 
SELECT T.FIELD_KEY, T.FIELD1, T.FIELD2, ... T.FIELD_N FROM (SELECT FIELD_KEY 
FROM T ORDER BY FIELD2) T2 JOIN T ON T.FIELD_KEY = T2.FIELD_KEY
why this can be faster then?
SELECT FIELD_KEY, FIELD1, FIELD2, ... FIELD_N FROM T ORDER BY FIELD2
Firebird sort whole resultset of "sorted key - Field2" or do different work?
I see in FB3 plan sort width and it looks like not true but?
 
regards,
Karol Bieniaszewski
 
 

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

23.05.2016 20:37, Bunth Tamás btom...@gmail.com [firebird-support] wrote:
> As far as I know,
> I shouldn't pass username/password in the spb to isc_service_attach() in 
> embedded mode.

   You don't need password, but user name must be.

-- 
   WBR, SD.

[firebird-support] Translating Firebird.MSG - pt_BR

['Heron Vieira' heron.vie...@guaranisistemas.com.br [firebird-support]]

[firebird-support] Backup in embedded mode using C API - authentication problem

[Bunth Tamás btom...@gmail.com [firebird-support]]

Hi,


I want to make a backup (.fbk) from a local database (.fdb). As far as I
know,
I shouldn't pass username/password in the spb to isc_service_attach() in
embedded mode. However,
I got an error during retrieving information with isc_service_query:


*Unable to perform operation.  You must be either SYSDBA or owner of the
database
*Exiting before completion due to errors
caused by
'isc_service_query'


So is it possible to backup a database in embedded mode?


Thank you,
Tamás Bunth