RE: [firebird-support] Hiding password step within innosetup
Thank you very much Sean
RE: [firebird-support] Hiding password step within innosetup
Thanks Sean for your suggestion but which way do I create my own project ? Get a copy of the project install script and make your own changes, or use the project script as a hint as to how you can include the steps into your own install kit. By the pre-created security database is that mean changing SYSDBA password as I done above ? No, it means installing Firebird on your machine, setting the SYSDBA password. Then copy the security2.fdb file into a location that will accessed to build your install kit, and include in your install script a command to place the file in the appropriate folder.
RE: [firebird-support] Hiding password step within innosetup
Thanks Sean for your suggestion but which way do I create my own project ? Sorry I did not explained the whole context. In innosetup script I include FB executable file with my app with the line below and change the SYSDBA password too: Filename: "{app}\firebird\Firebird-3.0.1.32609_0_Win32.exe"; Parameters: "/SYSDBAPASSWORD=XX /SP- /SILENT /NOGDS32 /NOCANCEL /DIR={code:GetServerPath} LOG={app}\install_log.txt / /COMPONENTS=""ServerComponent,ServerComponent\SuperServerComponent,DevAdminComponent,ClientComponent"""; Description: Launch application;StatusMsg: Installation du serveur de base de données;Check: GetParam1 By the pre-created security database is that mean changing SYSDBA password as I done above ? Is that enough ? Thanks.
RE: [firebird-support] Hiding password step within innosetup
> I need to know please if I can hide the password step when installing my app > with Firebird 3 within innosetup. > With FB 2 I can use the following parameter : > /SYSDBAPASSWORD, > /SP- /VERYSILENT, > /NOGDS32, > /NOCANCEL, > LOG > > We can only assign password in the SYSDBA step and don't know if exists the > possibilty of hiding the step. Suggestion: Don't use the project install kit, create your own, which ships a pre-created security database. That way you would never expose the password Sean
[firebird-support] Hiding password step within innosetup
Hello, I need to know please if I can hide the password step when installing my app with Firebird 3 within innosetup. With FB 2 I can use the following parameter : /SYSDBAPASSWORD, /SP- /VERYSILENT, /NOGDS32, /NOCANCEL, LOG We can only assign password in the SYSDBA step and don't know if exists the possibilty of hiding the step. Thanks.
Re: [firebird-support] Converting to firebird 3
Hi, Firebird 3 is not a silver bullet, it mostly increases performance in the multiprocessing area. With 30 connections, I would say that multiprocessing is not a problem, most likely you are having problems with SQL queries. I would suggest to take a look on https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/ https://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems Regards, Alexey Kovyazin IBSurgeon On 11.10.2017 12:35, 'Gian Uys' gian...@gmail.com [firebird-support] wrote: Hi We have an application with roughly 20 000 lines of code and have been using firebird 2.5 since the start. We do experience performance problems with 30+ client connections and are thinking of moving to firebird 3. Is firebird 3 drastically going to improve performance and how immense would the conversion to firebird 3 be? Thanks Gian
Re: [firebird-support] How I can speed up this query
Hallo, Il 11/10/2017 20.38, setysvar setys...@gmail.com [firebird-support] ha scritto: > I think this should give the same result as your query, whether or not > it is any quicker, I simply do not know (but I would love to hear if it > made any difference). Your query is to slow, flamerobin tells 4.360s. :( > PLAN (PNC2 NATURAL) > > seems to be your problem (PNC on the other hand, seems OK). > > Hence, if PARITA and/or SCADENZA are selective, I would recommend that > you create an index for either or both of these fields. That way, I > would assume your original query to become a lot quicker. Ok, I create an index for PARTITA and SCADENZA fields for PNC and Your query speed up, Flamerobin now tells 0.060s :) And, my query, now, flamerobin tells 0.045s :)) The secondary index are automatically maintained by server, is it right to do a periodically manually maintenance for it's? Thanks -- Luigi Siciliano -- ++ 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/