Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hi Geoff, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: At 02:36 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote: Doesn't that depend on how they implemented the separate threads? SS does/can use different threads for separate connections

Odp: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
Hi, I see 75 buffers - then i suppose you used default config. Increase defaultdbcachepages settings in firebird config and try again with superserver. I do not see other reason for 30 minutes calc.. Regards, Karol Bieniaszewski - Reply message - Od: t...@camalot.ca

[firebird-support] Execute statement on external does not enter default values in target table

2014-10-30 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi, it seems to me, that execute statement on external enters NULL in the target table in columns that are not mentioned in an insert statement - at least, the default values from domain definition are not used. Example: in test.fdb create domain D_TID as integer default current_transaction;

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread Geoff Worboys ge...@telesiscomputing.com.au [firebird-support]
'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: I once did a short video with a very simple/naive SMP capability test across SS and SC. http://www.iblogmanager.com/download/demos/firebird/fb25_architectures_smp.html Although with SS internally requests to the same

[firebird-support] numeric value is out of range

2014-10-30 Thread caste...@titelive.be [firebird-support]
Hi all, I try to figure out why i have a problem in my database since i convert it from firebird 1.5 (dialect 1, no charset ) to firebird 2.5 (dialect 3 and defined charset to utf8). The following SQL failed in the new database (fb 2.5 dialect 3). It worked in fb 1.5 (dialect 1).

Odp: [firebird-support] numeric value is out of range

2014-10-30 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
Hi, Did you run this outside ibexpert? What is exactly error message and code? Try it with flamerobin or fbsql. And then post info. Regards, Karol Bieniaszewski - Reply message - Od: caste...@titelive.be [firebird-support] firebird-support@yahoogroups.com Do:

RE: [firebird-support] numeric value is out of range

2014-10-30 Thread Marianne Castel - Titelive caste...@titelive.be [firebird-support]
Thanks for your reaction Karol, The exact message given by IBexpert is : can't format message 13:198 -- message file C:\Windows\firebird.msg not found. arithmetic exception, numeric overflow, or string truncation. numeric value is out of range. The error also occurs in our Delphi application

Re: [firebird-support] numeric value is out of range

2014-10-30 Thread 'm...@lawinegevaar.nl' m...@lawinegevaar.nl [firebird-support]
The definition of numeric calculation was changed between dialect 1 and 3 with Interbase 6. This is described in the Interbase 6 getting started (available from the website). Basically in dialect 1 this type of division overflowed into double precision, it doesn't in dialect 3 and your result

RE: [firebird-support] numeric value is out of range

2014-10-30 Thread Marianne Castel - Titelive caste...@titelive.be [firebird-support]
Thanks Mark. I’ll read the documentation again (for this). At migration time, I saw that we didn’t have fields with numeric definition… and i passed that section. But i didn’t noticed that we had “numeric” in our stored procedures…. And I fall on it now. Great thanks ! I go back to

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Oct 29, 2014, at 9:36 PM, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] firebird-support@yahoogroups.com wrote: Doesn't that depend on how they implemented the separate threads? SS does/can use different threads for separate connections to the same database, can't it?

[firebird-support] Re: Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread t...@camalot.ca [firebird-support]
Thanks

Re: [firebird-support] Should autosweep be happening on that database?

2014-10-30 Thread Ivan Arabadzhiev intelru...@yahoo.com [firebird-support]
Well, first of all - thank you for your time. Trace log still showed nothing but I finally noticed a pattern and talked to one of the devs (who didn`t know but has access to the source) - apparently I`m going to have to strangle someone who has never seen the size of a production database :)

[firebird-support] FB data type size and performance doubt , LIKE, fulltext

2014-10-30 Thread 'Alessandro Fedele' a.fed...@email.it [firebird-support]
Hi All I am new to FB and i am at design time evaluting some data types to choose for my DB I have some doubt on what to choose between “bigger” Varchar around 75char max and a Blob file type. My main doubt is wich one to prefer from 2 point of view : First , supposing I would have to store

[firebird-support] FB server installation and concurrent users limits on Windows Server

2014-10-30 Thread 'Alessandro Fedele' a.fed...@email.it [firebird-support]
Hi I know that FB as software doesnt have any limit to the users that can access the engine. I am wondering if is there any “access limit” imposed from a windows system server (like the latest 2008/2012) that will require to buy extra licenses I suppose that If I will install FB server on a

RE: [firebird-support] FB server installation and concurrent users limits on Windows Server

2014-10-30 Thread 'Louis van Alphen' lo...@nucleo.co.za [firebird-support]
There is no Windows imposed limit on the number of users. Even if you run on a server. Except of course if you deploy a client app on the server and users access it using RDP. Then each user would need a CAL, but otherwise , no restrictions. Do not run FB server on a serer that is a domain