RE: [firebird-support] Re: How to "shape" indexes to avoid index depth > 3

> > the multi-segment indexes are to optimize commonly used queries. > >In this case you can consider removing one or two fields from the index and > see how much selectivity it lose and how much performance would be > affected. So, you are saying that having less fields reduces the index

RE: [firebird-support] Re: How to "shape" indexes to avoid index depth > 3

> > All the FB articles/docs/postings that I have seen have said for > > performance, index depth should be no more than 3. > > This is not a hard requirement, 4 levels may be also OK. Are those multi- > segment indices primary/unique keys or just for lookup purposes? {Sorry for the delay in

[firebird-support] How to "shape" indexes to avoid index depth > 3

Hey all, In my database I have some indexes with depth = 4 (db page size is already 16KB). The indexes are multi-segment, with the fields sequenced from least to most selective, and gstat reports a very low selectivity for the index (less than 0.0001). The indexed tables have between 100

RE: [firebird-support] Unable to finish backup with GBK (Firebird 1.5)

Please read the “migrating” sections of v2.0, v2.1, v2.5 and v3.0 release notes. Going from v1.5 to v3.0 will likely involve several steps --you won’t necessarily have to do each of those steps, but your reading will tell what steps will be involved. Sean From:

RE: [firebird-support] Firing event when deleting in MON$ATTACHMENTS

> 2-POST_EVENT 'DISCONNECT_USER]'||:USR; (I splitt the event name using > "]" in the client in order to retrieve the event name part and the username > part) It is not fired What event is your application registered/listening for? 'DISCONNECT_USER]', or 'DISCONNECT_USER]'||:USR? Sean

RE: [firebird-support] Firing event when deleting in MON$ATTACHMENTS

> I am deleting user connected with: > DELETE FROM MON$ATTACHMENTS WHERE MON$ATTACHMENT_ID = > :ID_CONNECTION; > I need to use POST_EVENT in order to notify user that he has been > disconnected but don't found a trigger for MON$ATTACHMENTS to do it.  Can > you please help me ? AFAIK, it is not

RE: [firebird-support] "Invalid Cursor State"

It´s an executable procedure which returns a parameter. It´s not a selectable procedure. Its the kind of SP you invoke like "execute procedure ... returning values ..." while selectable ones are usually called as "select ... from stored_procedure_name" I´ve managed to fix my issue, anyway.

RE: [firebird-support] "Invalid Cursor State"

Dimitry: I do it all the time ... (read output parameters from executable procedures, using "call executable_sp" by ODBC). No issues with other SPs. Unless I missed something, your SP is missing the required SUSPEND to make the SP selectable. Regards 2017-10-17 15:38 GMT-03:00 Dimitry

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

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

RE: [firebird-support] Converting to firebird 3

> 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. You haven't provided any real details. Are you using SuperServer or

RE: [firebird-support] Cannot join CTEs (using indices) containing FIRST/ROWS/OFFSET

> As soon as i add the ROWS clause to a CTE FB cannot use indices available in > the CTEs tables. > Is this a bug, or as designed? > > This: > > with low as ( >   select igc.issue_id, ia.occasion >   from issues_groups igc >     left join issues_groups igb on (igb.issue_significant_id = >

RE: [firebird-support] "Name longer than database column size." on already compiled SP

> But, how that variable ended there? The SP is actually working, and I can get > the DDL with 33 char lenght variable name. >Could be a previous FB bug? Almost certainly. The bad variable name could have existed for years, only a change to the DDL/SP text would have caused the text to be

RE: [firebird-support] "Name longer than database column size." on already compiled SP

> I already have this SP in a DB (compiled, and using it a lot): No object (including SP variable) name can be longer than 31 characters Sean

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> Thank you for all the suggestions, I’ve changed the config as suggested, > unfortunately the problem still happens. > There seems to be little for me to investigate. > The latest crashes all occurred when there was very little load on the server > and on firebird. > > All access is done by php

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

>> From: firebird-support@yahoogroups.com [mailto:firebird- >> supp...@yahoogroups.com] >> Sent: sexta-feira, 18 de agosto de 2017 11:56 >> To: firebird-support@yahoogroups.com >> Subject: RE: [firebird-support] Firebird 3 crashes ( terminated abnormally >> (4294967295) ) >> >> > >What is the

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> >What is the size of the database pages? > >Have you checked the DB level Page Cache setting (the DB can have a > different value from the config)? > >How much RAM is available for the VM? > > Sean, theres 13gb of RAM, and no db with specific settings > Page size is 16k Ok, so a single

RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> I've been having quite a few crashes on a new server with not much > databases or requests. terminated abnormally (4294967295) > > It seems to be very random, there are not many different operations going > on. > > It's a google cloud Windows vm, I've checked for hardware / driver problems >

RE: [firebird-support] Automation tools?

Kjell, > We're in need of a tool where we can author sequences of SQL queries > against FB and non-DB commands like file operations etc. I'd like to call them > "batch runs" to perform recurring tasks. > > Do you know of such tools or what that kind of tool would be called in > general? > > We

RE: [firebird-support] nbackup : Error assessing database due a missing delta file

>There is a difference between "do not use it" and "do not use it with this > version". Unfortunately, in your later post you suggested that nbackup is never safe to use.

RE: [firebird-support] nbackup : Error assessing database due a missing delta file

> Hello Sean, I was replying to dimitry s. Have you read his response? > > As I understood he was saying to not use nbackup, and if one person > involved in any way to firebird says not to use it, then what make him think > to others? Let's just say that I find Dimitry S POV on many subject

RE: [firebird-support] nbackup : Error assessing database due a missing delta file

Jesus Garcia, > I only see three items pending, but anyway, why not remove Nbackup from > firebird until it is safe to use? As others have pointed out, the latest FB versions have an updated nbackup > Why is there a tool that cannot be used in a safe way? Q1: How do you *know* if a tool is

RE: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)

Robert, > the restore operation is running now for some minutes. > However I get very many (some thousand ??) messages of the form: > > gbak: do not recognize table attribute 0 -- continuing > > does this point to a serious problem or can I safely ignore it? You have a serious problem.

RE: [firebird-support] Compatibility questions: Current release versus 1.5.3.4870

My question (and I'm sorry if I'm asking this before doing any research on my own) is simply, how compatible is the 2.5 version with databases created with 1.5.3? There is no easy answer to your question – it depends… Have you considered rolling back the Win10 update? The update should

RE: [firebird-support] List of read only stored procedures.

Will, >    Is it possible to select a list of read only stored procedures from the > database. > >   I'd like to give my reporting engine access to stored procedures where they > fit the following rules > > 1.) Must be selectable > 2.) Must have no input parameters. > 3.) Must have one or more

RE: [firebird-support] RE: Firebird SuperClassic hangs

Thank you for your suggestion. I know that our configuration is not optimal and I will change this. But my understanding was, that this is only a performance problem and not something that can cause Firebird to hang. Or is this a known behavior? The problem is in the definition of “hang”.

[firebird-support] RE: Firebird SuperClassic hangs

Freddie, LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 25165824, Used: 24798216 Flags: 0x0001 Enqs: 17157097538, Converts: 22693011, Rejects: 12135777, Blocks: 93039760 Deadlock scans:289, Deadlocks: 1,

RE: [firebird-support]

> My problem is the increase in RAM when I start using my application under > Firebird 3 which is much more greedy, I switch from a usual 50mo > consumption to 200mo and more. Actually, your stats shows v2.5 using 174MB of RAM, whereas v3 uses 215MB > fb 2.5 : > • Memory > Current: 174 393 144

RE: {Disarmed} [firebird-support] Hint for maximaze FB performance, CPU Utilization - again.

> Each connection does get an single OS-thread only which can use no more > than an single core at the same time. On an 6-core CPU this means an > maximum of 16% utilization for total CPU. That is true for pre-v3.x SuperServer builds, not true for v3+ Not, was never, true for Classic or

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

> Today one of our customer complained that removing clients from > application is taking a lot of time around 30-40mins.  So I looked into their > database whose DB size is around 340MB and found that our DBA has a called > deletion triggers in main table. Triggers will delete all the client >

RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

hi Min=37ms Max=37ms Avg=37ms Does mean that but only selecting specific columns, your SQL executed faster? Also, are using v2.5+ FBClient library on remote client? thanks From: "'Leyne, Sean' s...@broadviewsoftware.com<mailto:s...@broadviewsoft

RE: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

> select * from MYTABLE where id=200 > > takes >    Total execution time: 5.388s >    PLAN (MYTABLE INDEX (PK_MYTABLE)) > >   the same query executed local on the server(same db,server) takes  0.065s > > queries are done with Flamerobin,from IBExpert the same results > > How can I improve

RE: [firebird-support] Best firebird3 server mode for high usage and concurrency

> Hello > Is SuperServer the best firebird3 if you have many large gdbs (about 100 of > gdbs averaging 2gb each) and very high concurrency? Define "very high concurrency". For the entire server? For specific databases? Sean

RE: [firebird-support] FBTrace: What are "dyn requests"

SET, > I don't know what dyn requests are, Sean, but reading a bit I do find dyn > mentioned in the Firebird book (page 1028) as well as on page 72 of a > presentation Pavel did at the Firebird conference 2014. First, the Firebird > book: > > A byte-encoded language for describing data

[firebird-support] FBTrace: What are "dyn requests"

FBTrace config supports the logging of "dyn requests", # Put dyn requests execute records log_dyn_requests false # Print dyn requests or not print_dyn false There is, however, no explanation of what these types of requests are -I don't recall "dyn requests"

RE: [firebird-support] Firebird Backups on Google Compute Engine

> We are considering moving our systems to GCE and trying to figure the best > approach to backup our many firebird databases. > Firebird is not VSS aware so we can't use shadow copying. Not completely true. 1- Firebird uses careful write order, so a VSS snapshot should be a valid database

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

> > OWNER BLOCK 732776 > > Owner id: 114332029419524, type: 1, pending: 0 > > Process id: 26620 (Alive), thread id: 2348 > > Flags: 0x08 wake > > Requests (431): forward: 732888, backward: 10111616 > > Blocks: *empty* > > 732776 waits on nothing. > > > >

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

Dmitry, > > Am I right to think that I need to create a process to run the command on a > regular basis (every 5 secs?) to find what objects locks are waiting for? > > Yes. But we're still guessing in the dark, the reason of the slowdown could be > completely unrelated to the lock manager (e.g.

RE: [firebird-support] Does any Delphi component exist to access a FB database without DLLs?

Andrea, I find your post contains contradictions. > I am looking to write a mobile application. > I don't want to use SQLite because I think it's crap. OK > Firebird seems just right, except that it comes with a massive DLL. "Massive"? Huh? The Firebird Client is ~1MB in size. What do

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

> > Am I right to think that I need to create a process to run the command on a > regular basis (every 5 secs?) to find what objects locks are waiting for? > > Yes. But we're still guessing in the dark That's fine, that is at least a path to investigate... >, the reason of the slowdown could

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

> > I asked for -w, not -iw. > > Or maybe -o -w, if just -w prints nothing. FYI, -w prints the same basic details -w -o prints some details -- reading Helen's book to understand what it is reporting. Am I right to think that I need to create a process to run the command on a regular basis

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

> Too many deadlock scans, it means long (> 10 sec) waiting for some locks. > Regular (every few minutes) fb_lock_print -w output could probably shed > some light... Here are some initial results C:\FIREBIRD\bin>fb_lock_print.exe -d x -iw 1 5000 01:08:29wait/s reject/s timeout/s

RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001

> > We have a client with 320GB database (running FB CS v2.5) > > Is it really so? FB does not support LockHashSlots more than 64K, it would > truncate your 90001 down to 65521. Is the engine that smart to trim to an exact prime number? > > Now, today, I checked the lock print values again,

[firebird-support] RE: High "Mutex wait" value, after increase in "Hash Slots" to 90001

I forgot to add, the disk subsystem that the database running on supports 200,000+ 8KB IOPS, so slow disk performance is not likely. > We have a client with 320GB database (running FB CS v2.5) reporting > performance issues, while we are investigating possible application sources, I > have been

[firebird-support] High "Mutex wait" value, after increase in "Hash Slots" to 90001

We have a client with 320GB database (running FB CS v2.5) reporting performance issues, while we are investigating possible application sources, I have been reviewing their Firebird config. Yesterday, I ran fb_lock_print to check on the database and found a "Mutex wait" value of 20.9%, which

RE: [firebird-support] Firebird 2.5 classic performance issue on linux64

Andreas, this is the one thing I am getting when I am connecting to the database. I am not the one working productively on the system, so I can't really tell wether this has become faster or is still the same. LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 7048576, Used:

RE: [firebird-support] Firebird 2.5 classic performance issue on linux64

> Sean: fb_lock_print seems to have some trouble: > > Unable to access lock table. > operating system directive shmem_data->sh_mem_length_mapped is 0 > failed -Success > > This is what I am getting from fb_lock_print -d filename.db0 You need to specific the full/local path to the database and

RE: [firebird-support] Firebird 2.5 classic performance issue on linux64

Andreas, > - increase page size to 16kB (gbak -> and restore with new pagesize) > - increased buffers for firebird to use up to 4GB of ram (256kB) via gfix With Classic server you *need* to reduce the number of cached pages -- I would recommend a value < 500 pages people keep telling me

RE: [firebird-support] Firebird 2.5 classic performance issue on linux64

Andreas, > - increase page size to 16kB (gbak -> and restore with new pagesize) > - increased buffers for firebird to use up to 4GB of ram (256kB) via gfix With Classic server you *need* to reduce the number of cached pages -- I would recommend a value < 500 pages > - switchted to async

RE: [firebird-support] Is there an easy way for input rows from a script file?

Walter, > If I connect to a database "Database1" using ISQL, I can write something like: > > OUTPUT MyFile.DAT; > SELECT * FROM MyTable; > OUTPUT; > > And all the rows of "MyTable" will go to the text file "MyFile.DAT". That's ok > and works fine. > > But now, I want to connect to "Database2",

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

> > There are times when I would love to be able to pivot data on the > > server, to further process the data an SP. > >SP cannot process queries with unknown number of fields. Neither client > part, BTW. Who said that the number of columns/fields was unknown? I could want to deal with a

RE: [firebird-support] Partial update

> > Is that the real issue, you want to eliminate the "prepare" stage? > >"Prepare" does much more than just parsing of query and building plan. It > also check for permissions and this stage cannot be cached. Not if the cache was in the context of the current connection, so permissions

RE: [firebird-support] Partial update

>If I use prepared statement like this "update table set field1=?, field2=? > where field3=?" for performance reasons, is there a way to update only > some fields and leave other untouched without overhead of building > separate queries on the fly or selecting old values with different

RE: [firebird-support] FIREBIRD PIVOT function or Matrix

> > Any suggestions on my DB design and query to display the values in matrix > (pivot) format? > >Simple client-side code can show you the matrix in any convenient form. > There is no point to do that on server. I disagree! There are times when I would love to be able to pivot data on

RE: [firebird-support] Weird behaviour

> A thread is trying to perform a SQL select, a client wants to display detailed > information for a certain row. > Basicly Select * from TABLE where PKEY = PKEY > The thread acquires lock in our server, then works it's way through GDS32.dll > (fbclient.dll) and then times out on the call to

RE: [firebird-support] Re: detect duplicate blobs, how to?

Richard, > Sean > Even SHA256 can’t eliminate all possibility of a duplicate. If you have files > of > more than 256 bits in them, by the pigeon hole principle, there WILL be > duplicates within the universe of all possible files. There HAS to be. The > probability is very low (but not zero) if

RE: [firebird-support] Is this a bug of Firebird?

Doug, > Delphi's latest compiler provides a hint in these cases: > > var >   x: Int32; > begin >   try >     x := 0; >     x := 1; >     writeln(x); > end. > > [dcc32 Hint] Project1.dpr(14): H2077 Value assigned to 'x' never used > (Line 14 is the one assigning zero.) In hindsight my post

RE: [firebird-support] Is this a bug of Firebird?

> Yes, but I can not know the value of the column X.ALU_NOMBRE > > And the idea, of course, is know that value, that's why it appears in the FOR > SELECT. If not, I can do nothing with X.ALU_NOMBRE You are asking for the system to evaluate the *intent* of logic. That is completely outside the

RE: [firebird-support] Migrating a 2.5 server

Luke > I would like to add a sub-topic in this discussion: currently, I'm using the > nbackup tool to run full/incremental backup. I'll have to update the Linux box > from CentOS 5.7 (2011) to Ubuntu 16.04 (current LTS). Considering both has > Firebird 2.5.x, is there any issue related to

RE: [firebird-support] firebird schema changes during backup

> On Mon, 23 Jan 2017 15:48:15 -0500 Dimitry Sibiryakov > mailto:s...@ibphoenix.com [firebird-support] supp...@yahoogroups.com> wrote > > Changing metadata is a bad idea in general. > Continuous development is the worst thing that can happen to a database. > > >

RE: Re: [firebird-support] FB 2.5 migrate to 3.0

James, Check that no other fbclient.dll or gds32.dll exist on you system… Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, January 9, 2017 6:59 PM To: firebird-support Subject: Re: Re: [firebird-support] FB

[firebird-support] RE: info

> We want to create table- and fieldnames (Firebird 3) in camelcase. You can do that now, you can use whatever case you want. > If we > want to write a select statement we have to use quotes around a tablename. > This is not userfriendly. Is there a way that we don't have to use the quotes >

RE: [firebird-support] Re: Why this procedure crashes server

Geoff, > I am curious as to why you are using dialect 1 on an FB3 database. > > Back when Interbase 6 was released the 1999 language reference said: > "Dialect 1 exists to ease the migration of legacy databases." Did IB 6 actually get released? My own memory has IB 6 in beta when Inprise

RE: [firebird-support] SS FB3.01 - Is it possible to set CPU utilization to max?

Anto, > During project development/testing or database maintenance, such as > backup/restore, mostly, there is only 1 connection to FB Server. > > I have 6 core processors and during those process, cpu's utilization is > about  16%. I knew, this is because there is only 1 connection to FB

RE: [firebird-support] Sequence

.. and can I order all active records completly? (without a loop) Don't manage the records during your direct update, manage the order records via a AFTER UPDATE trigger... Using a "separator" in the priority range is good, you can use it to manage the scope of the changes required. You

RE: [firebird-support] Sequence

Olag, > Before > Record 1 prio 3 > Record 2 prio 10 > Record 3 prio 18 > Record 4 prio 20 > Record 5 prio 30 > > The user set the record 4 to prio 15, I would like to do this: > > Record 1 from 3 to 10 > Record 2 from 10 to 20 > Record 3 from 20 (should 15, Destination between record 2 and

RE: [firebird-support] VIEW CREATES ON FB 2.5 BUT DO NOT CREATE ON FB 1.5

> Last row error > > Invalid Token. Dynamic SQL Error. Invalid Command Data Type unknown Try testing each SQL individually and then building up the SQL using different UNION combinations to see where the problem is. Sean

RE: [firebird-support] Re: Best way to delete millions of rows

> > @Ann > > I will run some test and see what happens if the guids are generated > > in way where the last part varies. Like this: > > 39db9ec6-178e-77b4-5d7b-d4e969b0cd98 > > 39db9ec6-178e-e4ba-54ed-92347a131663 > > 39db9ec6-178e-c95b-c709-a42e349410df > > There would be a lot of advantage, for

RE: [firebird-support] Digest Number 9396

The performance of the query may have been a function of the query approach itself, not the presence of the index From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, November 21, 2016 1:19 PM To: firebird-support@yahoogroups.com Subject: RE:

[firebird-support] tracker.firebirdsql.org and web.firebirdsql.org will be offline Tuesday November 22 from 20:00 to 24:00 EST

Sean

RE: [firebird-support] Digest Number 9396

> 1. I create those temporary tables for one user only, for one transaction > only, > not visible for other users. I keep a track (log) of those tables and delete > when I exit the program (drop table). All of that is already supported by temporary tables -- each connection creates a

RE: [firebird-support] Digest Number 9396

Dmitry, > 21.11.2016 16:22, tiberiu_horv...@yahoo.com [firebird-support] wrote: > > Hope this is all right now . > >No. The idea to create temporary tables on the fly and then drops them is > completely wrong for Firebird. "Wrong" is really not the correct word for this case. "Sub-optimal"

RE: [firebird-support] Digest Number 9396

> I do not declare domains. But you could! With just a little effort on your part. Take a little time, do the following: CREATE DOMAIN D_INTEGER AS Integer; CREATE DOMAIN D_Varchar_20 AS VARCHAR( 20); Then when you create your temporary tables just make 2 minor changes: create global

RE: [firebird-support] Optimizer request

> Still no changes. This looks to me as a riddle. > select orders.* > from > (select partid from partners where partners.country = ‘Spain’) T > JOIN orders ON orders.partid = T.partid Do you have an index on partners.country? If not, how do you expect the system to optimize the search?

RE: [firebird-support] Optimizer request

Try: select orders.* from (select partid from partners where partners.country = ‘Spain’) T JOIN orders ON orders.partid = T.partid From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: September 9, 2016 12:06 PM To: firebird-support@yahoogroups.com Subject:

[firebird-support] RE: Substring and negative numbers

Jeremy, > This simple query: > > SELECT left(c.addr_5, CHAR_LENGTH(c.addr_5)-3) as trimmed > FROM vecusts c > > > Produces this error No error was provided/included. Sean

RE: [firebird-support] gbak error

Nick, > it either happens on creation or a file is started and then removed very > quickly "then removed very quickly"??? Please elaborate. Sean

RE: [firebird-support] gbak error

> I'm running fb2.1 on centos5, recently a system has started throwing this > error when asked to do a backup, the gbak parameters are unchanged, > permissions all seem ok, any suggestions what I might check > > gbak: ERROR:Unexpected I/O error while writing to backup file > gbak:Exiting before

RE: [firebird-support] Help needed with grouping, GROUP BY and LIST()

Mike, What’s performance like? Sean From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: August 28, 2016 5:25 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Help needed with grouping, GROUP BY and LIST() Sean, Have a look at my

RE: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield

> >>> I'm using Firebird 2.5.2.26539. > >> > >> Any chance that another trigger is changing the value? > > > > I was thinking that myself, but Patrick said that it was the "old" value > > which > was being changed to the "new" value. > > Right. Perhaps NEW is changed to OLD? Patrick?? Please

RE: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield

Thomas, > > For some reason they both have the new value and I can't figure out why. > > If I didn't misread all the articles, I've found, completely, then > > they should be different, shouldn't they? > > > > > > I'm using Firebird 2.5.2.26539. > > Any chance that another trigger is changing

RE: [firebird-support] Number of Firebird Users

> How many concurrent users may be created and connect to a FireBird > database on such a Server ? > > Compaq Proliant ML 370 G1 > > Pentium III 667/133 Mhz 1.2GB RAM 256MB Cache Without a sense of the load/activity which would be placed on the server it is impossible to know. Also, details

RE: [firebird-support] Help needed with grouping, GROUP BY and LIST()

> > Q: Did you mean to exclude the 2nd "HIGH_FLOW" characteristic value from > > the summary? > > Yes, the same information should not be repeated within a single 'field'. The > second "HIGH_FLOW" characteristic is only in the original result set because > it > has 2 properties (> 10 litres /

RE: [firebird-support] Help needed with grouping, GROUP BY and LIST()

Mike, > Q2. How can I create a further table J_RESULT_GROUP and query for > arbitrarily grouping results together where any distinct elements are LIST()ed > whilst common elements are 'GROUP'ed (i.e. appear only once). For > example if J_RESULT_GROUP had 2 rows: > GROUP TEST > 1    2 > 1    44 >

RE: [firebird-support] Help needed with grouping, GROUP BY and LIST()

Mike, Some questions before I can give a suggestion: > TEST_ID    JFI_ID    F_NAME    N1_NAME    N2_NAME    MODE    CHARACTERIST > IC    PROPERTY > 1    1    FLOW_1    NODE_A    NODE_B    MODE_1    HIGH FLOW    > 10 litres  / > sec > 1    1    FLOW_1    NODE_A    NODE_B    MODE_1    HIGH FLOW   

RE: [firebird-support] Delete causes server to hang

> Anyway, right now there is not enough information - to investigate it, run > gstat -r -t < tablename > stat.txt Additionally, use gstat and extract the header page stats. This will allow for the OAT, OIT, and current transaction to be reviewed, and check the sweep interval setting. Sean

RE: [firebird-support] Delete causes server to hang

> On my website i have a tabel where i log some web requests - about > 90.000/hour. > > Every hour this SQL is executed in a stored procedure: > delete from requests where created < dateadd(-7 day to > current_timestamp); Do you have an index on "created"? Sean

RE: [firebird-support] SQL performance SS FB 3.0.1 vs SC FB 2.5.2

> Just found that on a particular case, SS FB 3.0.1 is about 4x slower than SC > FB > 2.5.2. > > Here is the query : > == > select a.id,b.nm from tbl1 a, tbl2 b > where a.id = b.id > and a.id in (select c.id from tbl3 c) > > If the query change to this : >

RE: [firebird-support] Cannot create simple table

> > It is only 27 characters in length! > >Exactly. This is a magic number. No, it is not! I have plenty of triggers with length = 31, without any issue.

RE: [firebird-support] Cannot create simple table

> > Any ideas? > >Shorten name of the PK_CUR_CASE_INV_NON_JUD_CNT constraint. Why? It is only 27 characters in length!

RE: [firebird-support] Cannot create simple table

> Trying to create a simple table and receive this error: > > unsuccessful metadata update > cannot create index PK_CUR_CASE_INV_NON_JUD_CNT > while executing: > ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT > FK_CUR_CASE_INV_RPT3 >   FOREIGN KEY (REPORT_ID) REFERENCES CUR_CASE_INV_RPT >

RE: [firebird-support] Server reboot during Windows exe setup?

> Is there a remote chance that this reboot has anything to do with the Firebird > installation then went on at that very second? Can it be related to the > installation of the Win32 runtimes that was going on at this time? The Firebird install would only prompt for a reboot as appropriate, it

RE: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa

> Am 14.07.2016 um 13:35 schrieb Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]: > > 14.07.2016 13:33, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > >> Is this bug in Firebird 3.0 client and is there workaround? > >This is a bug in BDE and you must ask for workaround at

RE: [firebird-support] FB 32 bits x FB 64 bits

> Dear Friends. > > One more time, a question around FirebirdSQL performance. > > I ran the same application before compiled 32 bits and after compiled 64 bits. > > The version compiled 64 bits ran  slowly  (much more) than 32 bits version. > > I dont believe this should be expected. Please

RE: [firebird-support] Query with few reads is slower than query with many reads. Which query to choose?

> I am trying select contracts together with the contract lines. around 30.000 > contracts and around 800.000 contract lines.  And I have two queries that to > essentially the same (each contract has at least one contract_line): ... > All the reads of both queries are indexed reads. > > The

RE: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

> >>> 3.0.1 hasn't been released yet, but snapshot builds are available here: > >>> http://www.firebirdsql.org/en/snapshot-builds/ > >>> > >> > >> the link is dead > > > > Works here. I get the entry page regarding snapshot builds for all > > branches and Windows/Linux. Anyway ... ;-) > > > >>

RE: [firebird-support] Is Firebird 3 ready for Production?

> 27.05.2016 15:26, 'Leyne, Sean' s...@broadviewsoftware.com [firebird- > support] wrote: > > Avalerion??? > >Yes. Sorry, I meant what is Avalerion??? Sean

RE: [firebird-support] Is Firebird 3 ready for Production?

>Especially at version 5 which is on pre-release stage now in accompany with > Avalerion. >http://www.ibphoenix.com/ibpr_devel/ Avalerion??? Sean

RE: [firebird-support] Re: SELECT WITH LOCK, WAIT transaction, deadlock

Dmitry, > 28.04.2016 16:19, Gabor Boros wrote: > > > In the language reference for "isc_tpb_read_committed + isc_tpb_wait" > > I see this: "Update conflict exceptions can never be raised by an > > explicit lock statement in this TPB mode." > > This is true for two concurrent transactions but

RE: [firebird-support] Re: [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

> 1) We have sweep set to 0. We do monitor the transaction gab and if > needed, we interact. Any kind of automatic sweep under high load will kill > the server :) 1- Do you run a manual sweep on a regular basis? 2- What is the CPU % like when Firebird "slows down"? 3- Have you tried using

  1   2   3   4   5   >