Re: [firebird-support] What is the optimum pageSize?
On 2019-11-17 12:22, jerz...@o2.pl [firebird-support] wrote: > On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel > m...@lawinegevaar.nl [firebird-support] wrote: >> Because it is hard to do. A lot of internals in Firebird and its >> clients >> rely on this maximum size (hint: the number itself fits in a 2-byte >> unsigned integer). It is not like you just need to update a >> MAX_ROW_SIZE >> constant and it is changed. > > I understand it's not trivial. But that's why there are new versions > like 3, 4 or now 5 to avoid such limitations. That is because there is a cost to everything, manpower is limited, and other things are considered more important to do. >> Consider that PostgreSQL has a limit of around 8KB (with its default >> page size). However, PostgreSQL has the advantage that variable length >> fields can be automatically stored out-of-line (ie basically as a >> blob, >> but that is transparent to the user). > > However, according to the documentation "row size" is much larger. But > maybe I am misreading this information. > > https://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F That is because that row size takes the out-of-line (toast) fields (max 1GB per field) into account. Out-of-line fields are similar to blobs, but they are less intrusive because - as far as I know - within the protocol they are communicated with the rowdata, instead of having to fetch them individually like you need to do with Firebird. Personally, I would prefer changes that make VARCHAR (and VARBINARY) practically unlimited and have Firebird do similar tricks like PostgreSQL to automatically store as a blob if a value is too long, but continue to communicate the data in-band in the protocol itself. Mark
Re: [firebird-support] How to index this table
Hi Karol, Thank you for your advices. Adding "simple" indexes on "MAGASIN" and "CAISSE" makes query running more slowly : 49s with indexes vs 44s without When the table is indexed on (ANNULE, TYPE_MOUVEMENT, DATEHEURE) they are not used at all. Regards, -- Pierre Yager On Fri, Nov 15, 2019 at 7:26 PM Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Hi > > > > Your problem is that you have (X or X) and (Y or Y) > > Firebird cannot use composite index here. > > Maybe it can somehow make something like (X1 and Y1) or (X1 and Y2) or … > or (X1 and YN) or (X2 and Y1) or (X2 and Y2) …. (XN and YN) > > But it will be never optimal. > > > > Create separate indexes for magasin and caisse – then Firebird can use > BITMAP OR + BITMAP AND > > > > Another optimisation will be instead of multiple OR put all values into > temporary table and then join with it. > > Any other optimisations depend on value propagation in particular fields > involved in the where clause. > > > > Regards, > > Karol Bieniaszewski > > >
Re: [firebird-support] How to index this table
Show the query plan.And what abput the second advice about temporary table istead of multiple or?Regards,Karol Bieniaszewski null
[firebird-support] ISC ERROR CODE:335544721
Hello, I have an ISC ERROR CODE:335544721 This is the message : ISC ERROR CODE:335544721ISC ERROR MESSAGE: Unable to complete network request to host "MYCOMPUTER".Failed to locate host machineUndefined service gds_db/tcp MYCOMPUTER : a Win 10 64bitsFirebird 2.58 Application written with Delphi +IBO The database is a local database...on MYCOMPUTER port 3050 tcp is open in enter and out… Do you have an idea of what I have to do ? With best regards,Mike
Re: [firebird-support] ISC ERROR CODE:335544721
18.11.2019 19:40, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: > Do you have an idea of what I have to do ? Remove Interbase client and use Firebird client to connect to Firebird. -- 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/
Re: [firebird-support] ISC ERROR CODE:335544721
Hello Dimitry, I havent' Interbase installed on this computer, only Firebird... I have desactivate the Frewall... Still have the same message... Strange, first time I've found this with win10 and Firebird… The same application work fine other computer with Firebird. With best regards,Mike Le lundi 18 novembre 2019 à 20:23:39 UTC+1, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit : 18.11.2019 19:40, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: > Do you have an idea of what I have to do ? Remove Interbase client and use Firebird client to connect to Firebird. -- 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
Re: [firebird-support] ISC ERROR CODE:335544721
hello, I haven't interbase installed… Only Firebird... With best regards, Mike
ODP: [firebird-support] ISC ERROR CODE:335544721
>>I havent' Interbase installed on this computer, only Firebird... Are you sure? Have you checked gds32.dll in Windows/System32 and Windows/SysWoW64 if it is Firebird? Regards, Karol Bieniaszewski
[firebird-support] Re: Unrecognized Service Parameter Block during FbBackup.Execute
thanks for the hint! I've installed version 3.0 and now I'm getting: unsupported on-disk structure for file C:\DATA\DATABASE.FDB; found 10.0, support 12.2 IProvider::attachDatabase failed when loading mapping cache No message for error code 336330835 found from FirebirdSql.Data.FirebirdClient. nice improvement… :) what's this error now? HELP!
Re: [firebird-support] ISC ERROR CODE:335544721
18.11.2019 20:38, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: > I havent' Interbase installed on this computer, only Firebird... Look better. Use Process Explorer to see versions and locations of DLLs loaded into your application. -- 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/
Re: [firebird-support] Re: Unrecognized Service Parameter Block during FbBackup.Execute
18.11.2019 21:12, fbianch...@yahoo.com [firebird-support] wrote: > what's this error now? Now you are trying to open Interbase database using Firebird server. This is no-go. -- 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/
Re: [firebird-support] ISC ERROR CODE:335544721
Hello, I have Firebird 2.58 32 bit version in the C:\Program Files (x86)\Firebird\Firebird_2_5 with best regards, Mike
Re: [firebird-support] ISC ERROR CODE:335544721
Hello Dimitry, I have all I use to find on other computer in C:\Program Files (x86)\Firebird\Firebird_2_5... With best regards,Mike Le lundi 18 novembre 2019 à 21:23:15 UTC+1, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit : 18.11.2019 20:38, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: > I havent' Interbase installed on this computer, only Firebird... Look better. Use Process Explorer to see versions and locations of DLLs loaded into your application. -- 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