Re: [firebird-support] Firebird running many databases
I'm jumping in late on this one, but I'm wondering if you could implement a single database that all users share but they are restricted to seeing only their own data. I know it isn't the question you asked, but I believe that many rows are more easily handled than many databases. I'm glad you got your problem fixed, but I fear it is only a matter of time before this issue pops up again. Good luck! Louis Kleiman On Wed, May 6, 2020 at 7:34 PM Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > Thank you for spelling that out - my deductive powers are weak. ;( > > Best regards > > On 6/05/2020 8:04 pm, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] wrote: > > 06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au > [firebird-support] wrote: > >> It just shows > >> > >> Firebird SQL Server (32 bit) > >> - Firebird Server - DefaultInstance > >> > >> No mention of the mode that I can see. > > You should also read documentation about differences between the > modes. Classic server > > runs process per attachment. > > > > > > > > > > ++ > > 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] Firebird running many databases
Thank you for spelling that out - my deductive powers are weak. ;( Best regards On 6/05/2020 8:04 pm, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support] > wrote: >> It just shows >> >> Firebird SQL Server (32 bit) >> - Firebird Server - DefaultInstance >> >> No mention of the mode that I can see. > You should also read documentation about differences between the modes. > Classic server > runs process per attachment. > ++ 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] Firebird running many databases
06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > It just shows > > Firebird SQL Server (32 bit) > - Firebird Server - DefaultInstance > > No mention of the mode that I can see. You should also read documentation about differences between the modes. Classic server runs process per attachment. -- 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] Firebird running many databases
It just shows Firebird SQL Server (32 bit) - Firebird Server - DefaultInstance No mention of the mode that I can see. On 6/05/2020 7:28 pm, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support] > wrote: >> Is there a way to check what mode FB v3.0 server is running in? > Windows Task Manager. > ++ 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] Firebird running many databases
06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > Is there a way to check what mode FB v3.0 server is running in? Windows Task Manager. -- 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] Firebird running many databases
Thanks Dimitry We have changed to 64-bit FB and it has significantly reduced the errors so I suspect it was RAM etc resource related. I will check firebird.log for more info. Is there a way to check what mode FB v3.0 server is running in? Is the only way to look at servermode in firebird.conf? Many thanks >>My application (Delphi using IBX) has started randomly raising exceptions "Error writing data to the connection" when the user queries their database. On 5/05/2020 9:22 pm, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > FB server version be better than the other in this scenario? > Yes. Recent versions used to be better than old ones. Classic server may > workaround > some problems while they are not fixed but still you must detect and > investigate them. > ++ 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] Firebird running many databases
04.05.2020 06:57, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > My application (Delphi using IBX) has started randomly raising > exceptions "Error writing data to the connection" when the user queries > their database. What is in server's firebird.log at this timestamp? > Would the number of databases being accessed cause load issues for FB? Yes. Each database uses own page and metadata cache. > Would one FB server version be better than the other in this scenario? Yes. Recent versions used to be better than old ones. Classic server may workaround some problems while they are not fixed but still you must detect and investigate them. -- 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/