Re: [firebird-support] Re: how to use the same column from a single table to other tables?
On Fri, May 3, 2013 at 8:07 PM, dice_in_trouble dice_in_trou...@yahoo.comwrote: You wrote: the client id also doens't auto increment. I asked How do you generate client identifiers? You responded What do you mean by client identifiers? I would like to summarize all the data in a certain column. Summarizing data can be done with computed columns, or with triggers. Triggers introduce a chance for deadlocks but perform better if you have a high read:write ratio because the sum doesn't have to be computed on reference. However, you also mentioned that your client_id field is not generated automatically. One way people get in trouble with Firebird is using something like setting an identifier column with an expression like identifier = MAX(identifier) + 1 I wondered if that was how you were creating unique identifiers. Good luck, Ann [Non-text portions of this message have been removed]
Re: [firebird-support] Re: use of -USE_ALL_SPACE
Hello, Nick! Thursday, May 2, 2013, 6:33:15 PM, you wrote: NU as I now understand it, if I restore the database with -USE_ALL_SPACE NU then do gfix -use reserve I will have a database which has all the static NU data on full pages and the data that does change will quickly go back to NU the 80/20 page usage. Something like 90% is static so I'm hoping this will No. I wonder where these rumours or false guesses comes from. No_reserve is a global switch, and after it is set, FB will not reserve space anymore at data pages. Gbak, as Ann said (and I says it constantly), is an ordinal application that inserts data to DB as any other application do. No magic, at all. For example, InterBase XE have new behavior and options to 1. change no_reserve option as ALTER DATABASE at runtime 2. change no_reserve option for selected tables. In Firebird, to set this option off, you may only use gfix, once, for all the database. And you can't do it during gbak. So, currently, this option in FB is only useful for read-only databases. That's it. Because option cannot be set for selected tables, only for the whole database. -- Dmitry Kuzmenko, www.ib-aid.com
[firebird-support] Re: how to use the same column from a single table to other tables?
--- In firebird-support@yahoogroups.com, Ann Harrison aharrison@... wrote: On Fri, May 3, 2013 at 8:07 PM, dice_in_trouble dice_in_trouble@...wrote: You wrote: the client id also doens't auto increment. I asked How do you generate client identifiers? You responded What do you mean by client identifiers? I would like to summarize all the data in a certain column. Summarizing data can be done with computed columns, or with triggers. Triggers introduce a chance for deadlocks but perform better if you have a high read:write ratio because the sum doesn't have to be computed on reference. However, you also mentioned that your client_id field is not generated automatically. One way people get in trouble with Firebird is using something like setting an identifier column with an expression like identifier = MAX(identifier) + 1 I wondered if that was how you were creating unique identifiers. Good luck, Ann [Non-text portions of this message have been removed] Thanks for the reply. Unfortunately I just put a char on the id and without a null option. I encountered once a problem because I used the number 1 already but have it deleted on the record, but I cannot use the number 1 again. Anyways I was planning to make the client ID automatically generates the numbers so that I will not mix up if the time comes that I have lots of data already encoded to the database. Regarding your answer regarding the summary. I honestly can't understand anything from deadlocks to triggers and identifiers. Thank you. Sincerely, Cedris
Re: [firebird-support] Re: how to use the same column from a single table to other tables?
Evening Cedris, When I'm in the office on Tuesday, ill send you some info. A crash course in Firebird. Cheers, Norm. Sent from my HTC [Non-text portions of this message have been removed]
Re: [firebird-support] Re: how to use the same column from a single table to other tables?
I'll se what I can come up with. Cheers, Norm. Sent from my HTC - Reply message - From: W O sistemas2000profesio...@gmail.com To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: how to use the same column from a single table to other tables? Date: Sat, May 4, 2013 22:13 Norman, if it don't disturbe you I want such course,too. Greetings. Walter. On Sat, May 4, 2013 at 5:06 PM, nor...@dunbar-it.co.uk nor...@dunbar-it.co.uk wrote: ** Evening Cedris, When I'm in the office on Tuesday, ill send you some info. A crash course in Firebird. Cheers, Norm. Sent from my HTC [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
[firebird-support] Re: Refreshing MON@ATTACHMENTS: Limiting the number of users
Can the initial, commited transaction transaction be a simple select query? --- In firebird-support@yahoogroups.com, Carlos H. Cantu listas@... wrote: h How can I force a refresh of MON$ATTACHMENTS from a Delphi application? Afaik, the only way is to commit actual transaction associated to the mon$ query, start a new transaction and run the query again. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br
[firebird-support] Re: how to use the same column from a single table to other tables?
--- In firebird-support@yahoogroups.com, nor...@dunbar-it.co.uk Norman@... wrote: Evening Cedris, When I'm in the office on Tuesday, ill send you some info. A crash course in Firebird. Cheers, Norm. Sent from my HTC [Non-text portions of this message have been removed] Good day Norm, Thank you very much. Have a nice day. Best regards, Cedris
[firebird-support] Re: fb_inet_server process with over 200 minutes runtime FB 1.5
Hi Thomas, we have upgraded to latest version of FB now. You mentioned that monitoring has improved since version 2.1. What would be the best way to monitor that process that is getting stuck. We were hoping it would simply go away with the move to the latest version of firebird but it has come back again. regards Chris --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: Hi Chris, Hi there I have a linux process (fb_inet_server) that has over 200 minutes runtime (and still running). Is there any way that I can see what sql this process is trying to run? Not with 1.5. Sorry. You may consider upgrading to 2.1 or later, because they have been improved a lot when it comes to monitoring. -- With regards, Thomas Steinmaurer http://www.upscene.com/