Re: [Firebird-devel] Win1252 Charset on MacOS
On 21/03/2018 15:01, Paul Beach wrote: > Email me privately It's better that port efforts be done here in the list. Adriano -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Win1252 Charset on MacOS
> >> After compiling firebird 2.5.8 on latest MacOS I run into problem that > >> win1252 charset seems to crash software when using embedded to open > >> local database file. > >> > >> When charset is specified on connect crash does happen there. > >> When connect is done using UTF8 crash does happen as soon as an table > >> defined with win1252 charset is accessed with reading sorted rows. > >> > >> How can I avoid (or further investigate) that problem? > > ? When you compiled it - what optimisation level did you use (if any)? > > just the defaults from configure script. Compilation is done using XCode > gcc-frontend. Email me privately, tell me exactly how you build fireird and then explain to me exactly how to reproduce the problem. When I get chance I will take a look at it. Unfortunately I am pretty busy at the moment. Regards Paul -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Win1252 Charset on MacOS
>> After compiling firebird 2.5.8 on latest MacOS I run into problem that >> win1252 charset seems to crash software when using embedded to open >> local database file. >> >> When charset is specified on connect crash does happen there. >> When connect is done using UTF8 crash does happen as soon as an table >> defined with win1252 charset is accessed with reading sorted rows. >> >> How can I avoid (or further investigate) that problem? > ? When you compiled it - what optimisation level did you use (if any)? just the defaults from configure script. Compilation is done using XCode gcc-frontend. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Win1252 Charset on MacOS
> After compiling firebird 2.5.8 on latest MacOS I run into problem that > win1252 charset seems to crash software when using embedded to open > local database file. > > When charset is specified on connect crash does happen there. > When connect is done using UTF8 crash does happen as soon as an table > defined with win1252 charset is accessed with reading sorted rows. > > How can I avoid (or further investigate) that problem? ? When you compiled it - what optimisation level did you use (if any)? Paul -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Win1252 Charset on MacOS
After compiling firebird 2.5.8 on latest MacOS I run into problem that win1252 charset seems to crash software when using embedded to open local database file. When charset is specified on connect crash does happen there. When connect is done using UTF8 crash does happen as soon as an table defined with win1252 charset is accessed with reading sorted rows. How can I avoid (or further investigate) that problem? Elmar -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5782) Execution of multiple stored procedures in some case is slow
Execution of multiple stored procedures in some case is slow Key: CORE-5782 URL: http://tracker.firebirdsql.org/browse/CORE-5782 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.3, 3.0.4 Reporter: Karol Bieniaszewski We are in point of migration of database from Interbase to Firebird and encountered slownes. Below query run slow ~1s. With same shema this query run instant on Interbase. We have analysed all procedures execution one by one and all looks fast with good plans. But as whole it is slow compared to Interbase. SELECT D.DYR_ID , D.DYR_NAZWA , D2.DYR_ID AS MA_DYR_UPR FROM DYREKCJA D LEFT JOIN Pracownik_dyr_akcja(49, 0, 'ARozrachunkiKsiegowane', '') D2 ON D2.DYR_ID = D.DYR_ID WHERE D.OBSZAR_ID = 1 AND D.DYR_ID <> 0 ORDER BY D.DYR_NAZWA COLLATE PXW_PLK ASC one point in comparision is that Firebird for above query use PLAN SORT (JOIN (D INDEX (FK_DYREKCJA__OBSZAR), D2 NATURAL)) but Interbase PLAN SORT (MERGE (SORT (D INDEX (RDB$FOREIGN323)),SORT ())) on Firebird there are 561598 fetches when on Interbase there is only 30199 fetches I have attached difference with stats and sample database to test -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel