Re: [firebird-support] Small Database with very very bad performance on LAN

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

> Hallo,
>
> Il 08/01/2016 16.22, Tim Ward t...@telensa.com [firebird-support] ha scritto:
>> What are your queries, query plans, query statistics?
>
> The queries are similar to: SELECT * FROM TABLE.
>
> Investigating for query plans, statistics, Buffers as suggested by
> Thomas, I discovered the origin of the problem:
> FB is innocent :) the guilty is me because I use ZEOSLib to connect to
> FB and I used the property "SortedFields" instead of using the clause
> "ORDER BY" in SQL query thinking that is more flexible on a Delphi RAD
> development like Delphi :(

A great use case for the Firebird Trace API to investigate what's up 
behind the scene of ZEOS. ;-)



-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.






++

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] Small Database with very very bad performance on LAN

[Luigi Siciliano luigi...@tiscalinet.it [firebird-support]]

Hallo,

Il 08/01/2016 16.30, Thomas Steinmaurer t...@iblogmanager.com 
[firebird-support] ha scritto:
> You have to sort out where your current bottleneck is.
>
> Can you pin-point it to a particular query or is performance in general
> bad? With Firebird 2.5, you have quite some monitoring amory, e.g.
> monitoring tables (tables starting with MON$...) or the Trace API.

The performance is bad in general, the navigation on a tables are too slow.

I find the problem, it's me that i used ZeosLib property "SortedFields" 
on a TQuery" component.

> Increase "Page buffers" to e.g. 1 (e.g. with gfix command-line
> tool), then re-connect your client application and see if this helps.
Before I Find the problem, seems not helps, it's a bit well but not helps.

> There is other tuning stuff,
I'm reading the Firebird Book written by Helen Borrie to understand the 
usage of FB but is hard reading over 1000 pages when the software must 
be ready for yesterday ;)

There are some other pages to read for undestrand the tuning of FB?

> getting a big picture on your slow statements, their
> execution plan probably pointing to missing indexes ... is a good start.

This helped me to find the problem.

> Good luck.

Thank you
-- 

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/

Re: [firebird-support] Small Database with very very bad performance on LAN

[Luigi Siciliano luigi...@tiscalinet.it [firebird-support]]

Hallo,

Il 08/01/2016 16.22, Tim Ward t...@telensa.com [firebird-support] ha scritto:
> What are your queries, query plans, query statistics?

The queries are similar to: SELECT * FROM TABLE.

Investigating for query plans, statistics, Buffers as suggested by 
Thomas, I discovered the origin of the problem:
FB is innocent :) the guilty is me because I use ZEOSLib to connect to 
FB and I used the property "SortedFields" instead of using the clause 
"ORDER BY" in SQL query thinking that is more flexible on a Delphi RAD 
development like Delphi :(

Now the application seems faster and works best of the same application 
that use BDE :)

Thanks to all.

-- 

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/

[firebird-support] Re: An SQL query perform badly after firebird database file size grow beyond 8GB

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

cyc...@gmail.com [firebird-support] a écrit :
>
>  Is this an issue related to Windows file system? Firebird service or my 
> query?

for test :

  SELECT MAX(A.PostDate) MaxPostDate from (
  select a.postdate
  FROM SL_CS A, SL_CSDTL B
  WHERE A.DocKey=B.DocKey
AND A.Code='300-10001'
AND B.ItemCode='OCC'
AND B.UOM='UNIT'
AND A.Cancelled='F'
AND B.UnitPrice<>0)

-- 
Norbert Saint Georges
http://tetrasys.fi







++

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] An SQL query perform badly after firebird database file size grow beyond 8GB

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi,

There should a reason why optimizer chooses the wrong plan.
Try to recalculate indices statistics.

Also, for general performance, use optimized Firebird configuration:
http://ib-aid.com/en/optimized-firebird-configuration/

Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com

I am using Firebird 2.5.5 x64 on Windows 8.1 x64.  I wrote an 
application access a Firebird database.  So far so good.



One day, I notice a function running query accessing the database 
become extremely slow.  After I debug, I found the query is the cause:



SELECT MAX(A.PostDate) MaxPostDate

FROM SL_CS A, SL_CSDTL B

WHERE A.DocKey=B.DocKey

  AND A.Code='300-10001'

  AND B.ItemCode='OCC'

  AND B.UOM='UNIT'

  AND A.Cancelled='F'

  AND B.UnitPrice<>0


Further investigation and I found an interesting problem.  If the 
database file size is below 8GB, the query works normal.  Once the 
database file size grow beyond 8GB, the query become very slow.



Here is the plan before 8GB:


PLAN JOIN (B INDEX (SL_CSDTL_ITEMCODE), A INDEX (RDB$PRIMARY212))


Adapted Plan

PLAN JOIN (B INDEX (SL_CSDTL_ITEMCODE), A INDEX (INTEG_2872))


-- Performance info --

Prepare time = 0ms

Execute time = 312ms

Avg fetch time = 312.00 ms

Current memory = 14,858,352

Max memory = 14,972,720

Memory buffers = 2,048

Reads from disk to cache = 42,429

Writes from cache to disk = 0

Fetches from cache = 360,726


And the plan after grow to 8GB:


PLAN JOIN (A INDEX (SL_CS_CODE), B INDEX (SL_CSDTL_DOCKEY,
SL_CSDTL_ITEMCODE))


-- Performance info --

Prepare time = 0ms

Execute time = 2m 0s 875ms

Avg fetch time = 120,875.00 ms

Current memory = 14,943,040

Max memory = 15,005,768

Memory buffers = 2,048

Reads from disk to cache = 44,818

Writes from cache to disk = 0

Fetches from cache = 11,454,178

Both plan works on same tables with same row count.  Increasing of 
database file size is due to insertion on other tables.  I believe the 
performance issue was due to "Fetches from cache" increasing 
dramatically on 2nd plan.



Is this an issue related to Windows file system? Firebird service or 
my query?

[firebird-support] An SQL query perform badly after firebird database file size grow beyond 8GB

[cyc...@gmail.com [firebird-support]]

I am using Firebird 2.5.5 x64 on Windows 8.1 x64.  I wrote an application 
access a Firebird database.  So far so good.
 

 One day, I notice a function running query accessing the database become 
extremely slow.  After I debug, I found the query is the cause:
 

 SELECT MAX(A.PostDate) MaxPostDate
 FROM SL_CS A, SL_CSDTL B
 WHERE A.DocKey=B.DocKey 
   AND A.Code='300-10001' 
   AND B.ItemCode='OCC' 
   AND B.UOM='UNIT' 
   AND A.Cancelled='F' 
   AND B.UnitPrice<>0
 

 Further investigation and I found an interesting problem.  If the database 
file size is below 8GB, the query works normal.  Once the database file size 
grow beyond 8GB, the query become very slow.
 

 Here is the plan before 8GB:
 

 PLAN JOIN (B INDEX (SL_CSDTL_ITEMCODE), A INDEX (RDB$PRIMARY212))
 

 Adapted Plan
 PLAN JOIN (B INDEX (SL_CSDTL_ITEMCODE), A INDEX (INTEG_2872))
 

 -- Performance info --
 Prepare time = 0ms
 Execute time = 312ms
 Avg fetch time = 312.00 ms
 Current memory = 14,858,352
 Max memory = 14,972,720
 Memory buffers = 2,048
 Reads from disk to cache = 42,429
 Writes from cache to disk = 0
 Fetches from cache = 360,726
 

 And the plan after grow to 8GB:
 

 PLAN JOIN (A INDEX (SL_CS_CODE), B INDEX (SL_CSDTL_DOCKEY, SL_CSDTL_ITEMCODE))
 

 -- Performance info --
 Prepare time = 0ms
 Execute time = 2m 0s 875ms
 Avg fetch time = 120,875.00 ms
 Current memory = 14,943,040
 Max memory = 15,005,768
 Memory buffers = 2,048
 Reads from disk to cache = 44,818
 Writes from cache to disk = 0
 Fetches from cache = 11,454,178
 Both plan works on same tables with same row count.  Increasing of database 
file size is due to insertion on other tables.  I believe the performance issue 
was due to "Fetches from cache" increasing dramatically on 2nd plan.

 

 Is this an issue related to Windows file system? Firebird service or my query?
 
 

 

Re: [firebird-support] Need Support to connect to the database

[Daniel Rail dan...@accra.ca [firebird-support]]

[firebird-support] Small Database with very very bad performance on LAN

[Luigi Siciliano luigi...@tiscalinet.it [firebird-support]]

Hallo,
   I have a small database (less 100MB)  that works on Firebird 2.5.5 
SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.

I seems to work very well in local but with the 3 clients on LAN works 
very bad. It is very very slow to open and navigate a simple table with 
less of 5.000 rows!

What i can do?

I very novice in Firebird.

The result of gstat is:
Database header page information:
 Flags   0
 Checksum12345
 Generation  26613
 Page size   4096
 ODS version 11.2
 Oldest transaction  26603
 Oldest active   26604
 Oldest snapshot 26604
 Next transaction26605
 Bumped transaction  1
 Sequence number 0
 Next attachment ID  139
 Implementation ID   26
 Shadow count0
 Page buffers0
 Next header page0
 Database dialect3
 Creation date   Jan 4, 2016 15:44:10
 Attributes  force write

 Variable header data:
 Sweep interval: 2
 *END*

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/

Re: [firebird-support] Small Database with very very bad performance on LAN

[Daniel Rail dan...@accra.ca [firebird-support]]

Hi,

At January 8, 2016, 7:50 AM, Luigi Siciliano luigi...@tiscalinet.it 
[firebird-support] wrote:

> Hallo,
>I have a small database (less 100MB)  that works on Firebird 2.5.5 
> SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.

> I seems to work very well in local but with the 3 clients on LAN works
> very bad. It is very very slow to open and navigate a simple table with
> less of 5.000 rows!

> What i can do?

Have you tried with SuperClassic or Classic? SuperServer 2.5.5 still
is a single thread per database, so basically all connections to one
database, all share the same thread. While SuperClassic, uses one
thread per connection and Classic uses one instance per connection.
With SuperServer 3.0, it will be a true multi-threaded environment
where you shouldn't see this kind of performance hit, since each
connection should be using their own thread.

At the beginning, we were using SuperServer, but after customers
reporting slowdowns, when at least one user was doing something in the
software that did use a lot of resources out of Firebird(i.e.: a
report with data analysis). We decided to try Classic(SuperClassic
wasn't available at the time), and our customers are not longer
reporting those slowdowns.

So,  give  Classic  or  SuperClassic a try.  Unless, if you still want
SuperServer, give Firebird 3 Superserver Release Candidate 1 a try.

> I very novice in Firebird.

> The result of gstat is:
> Database header page information:
>  Flags   0
>  Checksum12345
>  Generation  26613
>  Page size   4096
>  ODS version 11.2
>  Oldest transaction  26603
>  Oldest active   26604
>  Oldest snapshot 26604
>  Next transaction26605
>  Bumped transaction  1
>  Sequence number 0
>  Next attachment ID  139
>  Implementation ID   26
>  Shadow count0
>  Page buffers0
>  Next header page0
>  Database dialect3
>  Creation date   Jan 4, 2016 15:44:10
>  Attributes  force write

>  Variable header data:
>  Sweep interval: 2
>  *END*

These stats are really good.  Are they taken when the slowdown occurs,
with  all  the connections and queries active, or is it after they are
closed?  Also, make certain that you are using a read-only transaction
for  reading  the  data  and  use  a  short  read/write transaction to
insert/update/delete data.

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

[firebird-support] Architecture

['checkmail' check_m...@satron.de [firebird-support]]

Hello,

 

I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to Firebird
2.5. Is there a 64 Bit OS recommend and a 64 Bit installation of Firebird
too? I connect with odbc. Known Issues while migration, metadata etc. ?

 

Thanks in advance.

 

Best regards.

 

Olaf

 

 

 

 

Re: AW: [firebird-support] Architecture

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

> Thanks. For some Years, we have had in use the superserver, but since we
> have a quadcore CPU, we are using cs.
>
> UDFs can I replace with build in functions

I guess you can imagine that you first need to do that before backing up 
and restoring?

> Now, I have restored the database with 2.5, but.. Errors :( Now I have seen
> the new switches -fix_fss_d and m, but now I get another error, no character
> set were found.

* What is the character set of your database used when you have created 
the database in the past?
* What is the exact error message?
* How did you install Firebird 2.5?

Is there another way to migrate? With the scripts while
> running 2.1?

backup/restore via gbak is the preferred solution, because it also moves 
data. Of course, you still can create an empty Firebird 2.5 based 
database with a DDL script and then pump your data with a tool from
your source into the destination database.


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.



>
> thanks
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:37
> An: firebird-support@yahoogroups.com
> Betreff: Re: [firebird-support] Architecture
>
> Hello Olaf,
>
>> Hello,
>>
>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation
>> of Firebird too?
>
>   From an operational POV, a main factor with moving from 32-bit to 64-bit is
> if you are using (third-party) UDF libraries. You need them to be compiled
> with a 64-bit compiler if you want to run Firebird 64-bit.
>
> Other than that, I guess it depends on your planned load, especially
> addressable RAM by the Firebird server process. If still intend to run with
> ClassicServer, then each connection spawns its own process, thus you
> probably won't hit the addressable RAM limit with Firebird 32-bit.
> That might be different with Firebird SuperClassic (32-bit), because this is
> a single process architecture.
>
> I connect with odbc. Known Issues while migration,
>> metadata etc. ?
>
> The usual path is creating a gbak-based backup with Firebird 2.1 and restore
> it under Firebird 2.5. The resulting ODS will be 11.2 (you can check with
> gstat -h afterwards).
>
> On the client side, make sure that you are using a version of the Firebird
> client library matching the server version. Bitness (32-bit vs.
> 64-bit) of the client library is driven by your application and not by the
> Firebird server. So, if you are application is 32-bit (Delphi
> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>
> Hope this helps.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
> Database Health Check, Tuning etc.
>
>
> 
>
> 
>
> ++
>
> 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
>
>
>
>
>
> 
> Posted by: "checkmail" 
> 
>
> ++
>
> 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
>
>
>








++

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 

AW: [firebird-support] Small Database with very very bad performance on LAN

['checkmail' check_m...@satron.de [firebird-support]]

Verbose :)

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 16:30
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Small Database with very very bad
performance on LAN

Hello,

> Hallo,
> I have a small database (less 100MB)  that works on Firebird 2.5.5 
> SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.
>
> I seems to work very well in local but with the 3 clients on LAN works 
> very bad. It is very very slow to open and navigate a simple table 
> with less of 5.000 rows!
>
> What i can do?

You have to sort out where your current bottleneck is.

Can you pin-point it to a particular query or is performance in general bad?
With Firebird 2.5, you have quite some monitoring amory, e.g. 
monitoring tables (tables starting with MON$...) or the Trace API.

Try to get a big picture with that tooling to see what's going, statement
execution plans etc..., I/O statistics, e.g. is data being fetched from disk
or served from the Firebird cache, which I doubt with your page buffers
value below.

>
> I very novice in Firebird.
>
> The result of gstat is:
> Database header page information:
>   Flags   0
>   Checksum12345
>   Generation  26613
>   Page size   4096
>   ODS version 11.2
>   Oldest transaction  26603
>   Oldest active   26604
>   Oldest snapshot 26604
>   Next transaction26605
>   Bumped transaction  1
>   Sequence number 0
>   Next attachment ID  139
>   Implementation ID   26
>   Shadow count0
>   Page buffers0
>   Next header page0
>   Database dialect3
>   Creation date   Jan 4, 2016 15:44:10
>   Attributes  force write
>
>   Variable header data:
>   Sweep interval: 2
>   *END*

With SuperServer and a page size of 4096 and a page buffers set of 0, which
gets overriden with a default value of 2048 from firebird.conf (if not
specified otherwise), you end up with a Firebird page cache of 8MB
(!) only for your database.

Increase "Page buffers" to e.g. 1 (e.g. with gfix command-line tool),
then re-connect your client application and see if this helps.

There is other tuning stuff, but as a first step increasing the Firebird
page cache + getting a big picture on your slow statements, their execution
plan probably pointing to missing indexes ... is a good start.

Good luck.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.






++

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] Small Database with very very bad performance on LAN

[Tim Ward t...@telensa.com [firebird-support]]

On 08/01/2016 11:50, Luigi Siciliano luigi...@tiscalinet.it 
[firebird-support] wrote:
> Hallo,
> I have a small database (less 100MB)  that works on Firebird 2.5.5
> SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.
>
> I seems to work very well in local but with the 3 clients on LAN works
> very bad. It is very very slow to open and navigate a simple table with
> less of 5.000 rows!
>
> What i can do?
What are your queries, query plans, query statistics?

-- 
Tim Ward







++

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] Architecture

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

Hello Olaf,

> Hello,
>
> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation
> of Firebird too?

 From an operational POV, a main factor with moving from 32-bit to 
64-bit is if you are using (third-party) UDF libraries. You need them to 
be compiled with a 64-bit compiler if you want to run Firebird 64-bit.

Other than that, I guess it depends on your planned load, especially 
addressable RAM by the Firebird server process. If still intend to run 
with ClassicServer, then each connection spawns its own process, thus 
you probably won't hit the addressable RAM limit with Firebird 32-bit. 
That might be different with Firebird SuperClassic (32-bit), because 
this is a single process architecture.

I connect with odbc. Known Issues while migration,
> metadata etc. ?

The usual path is creating a gbak-based backup with Firebird 2.1 and 
restore it under Firebird 2.5. The resulting ODS will be 11.2 (you can 
check with gstat -h afterwards).

On the client side, make sure that you are using a version of the 
Firebird client library matching the server version. Bitness (32-bit vs. 
64-bit) of the client library is driven by your application and not by 
the Firebird server. So, if you are application is 32-bit (Delphi 
32-bit?) use a Firebird 32-bit client library and ODBC driver.

Hope this helps.

-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.






++

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/

AW: [firebird-support] Architecture

['checkmail' check_m...@satron.de [firebird-support]]

Hello Thomas,

Thanks. For some Years, we have had in use the superserver, but since we
have a quadcore CPU, we are using cs.

UDFs can I replace with build in functions

Now, I have restored the database with 2.5, but.. Errors :( Now I have seen
the new switches -fix_fss_d and m, but now I get another error, no character
set were found. Is there another way to migrate? With the scripts while
running 2.1?

thanks

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 16:37
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Architecture

Hello Olaf,

> Hello,
>
> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit installation 
> of Firebird too?

 From an operational POV, a main factor with moving from 32-bit to 64-bit is
if you are using (third-party) UDF libraries. You need them to be compiled
with a 64-bit compiler if you want to run Firebird 64-bit.

Other than that, I guess it depends on your planned load, especially
addressable RAM by the Firebird server process. If still intend to run with
ClassicServer, then each connection spawns its own process, thus you
probably won't hit the addressable RAM limit with Firebird 32-bit. 
That might be different with Firebird SuperClassic (32-bit), because this is
a single process architecture.

I connect with odbc. Known Issues while migration,
> metadata etc. ?

The usual path is creating a gbak-based backup with Firebird 2.1 and restore
it under Firebird 2.5. The resulting ODS will be 11.2 (you can check with
gstat -h afterwards).

On the client side, make sure that you are using a version of the Firebird
client library matching the server version. Bitness (32-bit vs. 
64-bit) of the client library is driven by your application and not by the
Firebird server. So, if you are application is 32-bit (Delphi
32-bit?) use a Firebird 32-bit client library and ODBC driver.

Hope this helps.

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.






++

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

AW: AW: AW: AW: [firebird-support] Architecture

['checkmail' check_m...@satron.de [firebird-support]]

-verbose :) I remember me. 

So I can see what table is he problematic one.

Have a nice weekend, Thomas, many Thanks :)

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 17:28
An: firebird-support@yahoogroups.com
Betreff: Re: AW: AW: AW: [firebird-support] Architecture

> Yes, Thomas,
>
> it woks with 2.1. In the release notes of 2.5.X is written:
>
> Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would 
> throw the error "value exceeds the range for valid timestamp".
>
> But where can I search 200 Tables...

Read Paul's blog on using -v for the restore etc ...


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.


> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 17:07
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: AW: [firebird-support] Architecture
>
>> now, the switches works fine, I had forget the Charset -fix_fss_d
>> ISO8859_1
>>
>> It works fine, but there is another problem to fix. Now I get the 
>> error, that value exceeds the range for valid timestamps. How can I 
>> fix
> this issue?
>
> * When does that happen during the restore?
> * Does a backup *AND* restore with Firebird 2.1 works?
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>> I have installed fb as cs without superclassic under 32 Bit Win7 the
>> 32 Bit Version
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com 
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:51
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: AW: [firebird-support] Architecture
>>
>>> Thanks. For some Years, we have had in use the superserver, but 
>>> since we have a quadcore CPU, we are using cs.
>>>
>>> UDFs can I replace with build in functions
>>
>> I guess you can imagine that you first need to do that before backing 
>> up and restoring?
>>
>>> Now, I have restored the database with 2.5, but.. Errors :( Now I 
>>> have seen the new switches -fix_fss_d and m, but now I get another 
>>> error, no character set were found.
>>
>> * What is the character set of your database used when you have 
>> created the database in the past?
>> * What is the exact error message?
>> * How did you install Firebird 2.5?
>>
>> Is there another way to migrate? With the scripts while
>>> running 2.1?
>>
>> backup/restore via gbak is the preferred solution, because it also 
>> moves data. Of course, you still can create an empty Firebird 2.5 
>> based database with a DDL script and then pump your data with a tool 
>> from your source into the destination database.
>>
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird FB TraceManager, IB 
>> LogManager, Database Health Check, Tuning etc.
>>
>>
>>
>>>
>>> thanks
>>>
>>> -Ursprüngliche Nachricht-
>>> Von: firebird-support@yahoogroups.com 
>>> [mailto:firebird-support@yahoogroups.com]
>>> Gesendet: Freitag, 8. Januar 2016 16:37
>>> An: firebird-support@yahoogroups.com
>>> Betreff: Re: [firebird-support] Architecture
>>>
>>> Hello Olaf,
>>>
 Hello,

 I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
 Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
 installation of Firebird too?
>>>
>>> From an operational POV, a main factor with moving from 32-bit 
>>> to 64-bit is if you are using (third-party) UDF libraries. You need 
>>> them to be compiled with a 64-bit compiler if you want to run Firebird
64-bit.
>>>
>>> Other than that, I guess it depends on your planned load, especially 
>>> addressable RAM by the Firebird server process. If still intend to 
>>> run with ClassicServer, then each connection spawns its own process, 
>>> thus you probably won't hit the addressable RAM limit with Firebird
> 32-bit.
>>> That might be different with Firebird SuperClassic (32-bit), because 
>>> this is a single process architecture.
>>>
>>> I connect with odbc. Known Issues while migration,
 metadata etc. ?
>>>
>>> The usual path is creating a gbak-based backup with Firebird 2.1 and 
>>> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you 
>>> can check with gstat -h afterwards).
>>>
>>> On the client side, make sure that you are using a version of the 
>>> Firebird client library matching the server version. Bitness (32-bit vs.
>>> 64-bit) of the client library is driven by your application and not 
>>> by the Firebird server. So, if you are application is 32-bit (Delphi
>>> 32-bit?) use a Firebird 32-bit client library and ODBC 

Re: [firebird-support] Small Database with very very bad performance on LAN

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

Hello,

> Hallo,
> I have a small database (less 100MB)  that works on Firebird 2.5.5
> SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.
>
> I seems to work very well in local but with the 3 clients on LAN works
> very bad. It is very very slow to open and navigate a simple table with
> less of 5.000 rows!
>
> What i can do?

You have to sort out where your current bottleneck is.

Can you pin-point it to a particular query or is performance in general 
bad? With Firebird 2.5, you have quite some monitoring amory, e.g. 
monitoring tables (tables starting with MON$...) or the Trace API.

Try to get a big picture with that tooling to see what's going, 
statement execution plans etc..., I/O statistics, e.g. is data being 
fetched from disk or served from the Firebird cache, which I doubt with 
your page buffers value below.

>
> I very novice in Firebird.
>
> The result of gstat is:
> Database header page information:
>   Flags   0
>   Checksum12345
>   Generation  26613
>   Page size   4096
>   ODS version 11.2
>   Oldest transaction  26603
>   Oldest active   26604
>   Oldest snapshot 26604
>   Next transaction26605
>   Bumped transaction  1
>   Sequence number 0
>   Next attachment ID  139
>   Implementation ID   26
>   Shadow count0
>   Page buffers0
>   Next header page0
>   Database dialect3
>   Creation date   Jan 4, 2016 15:44:10
>   Attributes  force write
>
>   Variable header data:
>   Sweep interval: 2
>   *END*

With SuperServer and a page size of 4096 and a page buffers set of 0, 
which gets overriden with a default value of 2048 from firebird.conf (if 
not specified otherwise), you end up with a Firebird page cache of 8MB 
(!) only for your database.

Increase "Page buffers" to e.g. 1 (e.g. with gfix command-line 
tool), then re-connect your client application and see if this helps.

There is other tuning stuff, but as a first step increasing the Firebird 
page cache + getting a big picture on your slow statements, their 
execution plan probably pointing to missing indexes ... is a good start.

Good luck.
-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.






++

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/

AW: AW: AW: [firebird-support] Architecture

['checkmail' check_m...@satron.de [firebird-support]]

Yes, Thomas,

it woks with 2.1. In the release notes of 2.5.X is written:

Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw
the error "value exceeds the range for valid timestamp".

But where can I search 200 Tables...

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 17:07
An: firebird-support@yahoogroups.com
Betreff: Re: AW: AW: [firebird-support] Architecture

> now, the switches works fine, I had forget the Charset -fix_fss_d 
> ISO8859_1
>
> It works fine, but there is another problem to fix. Now I get the 
> error, that value exceeds the range for valid timestamps. How can I fix
this issue?

* When does that happen during the restore?
* Does a backup *AND* restore with Firebird 2.1 works?


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.

> I have installed fb as cs without superclassic under 32 Bit Win7 the 
> 32 Bit Version
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:51
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: [firebird-support] Architecture
>
>> Thanks. For some Years, we have had in use the superserver, but since 
>> we have a quadcore CPU, we are using cs.
>>
>> UDFs can I replace with build in functions
>
> I guess you can imagine that you first need to do that before backing 
> up and restoring?
>
>> Now, I have restored the database with 2.5, but.. Errors :( Now I 
>> have seen the new switches -fix_fss_d and m, but now I get another 
>> error, no character set were found.
>
> * What is the character set of your database used when you have 
> created the database in the past?
> * What is the exact error message?
> * How did you install Firebird 2.5?
>
> Is there another way to migrate? With the scripts while
>> running 2.1?
>
> backup/restore via gbak is the preferred solution, because it also 
> moves data. Of course, you still can create an empty Firebird 2.5 
> based database with a DDL script and then pump your data with a tool 
> from your source into the destination database.
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>
>
>>
>> thanks
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com 
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:37
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: [firebird-support] Architecture
>>
>> Hello Olaf,
>>
>>> Hello,
>>>
>>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
>>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
>>> installation of Firebird too?
>>
>>From an operational POV, a main factor with moving from 32-bit to 
>> 64-bit is if you are using (third-party) UDF libraries. You need them 
>> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>>
>> Other than that, I guess it depends on your planned load, especially 
>> addressable RAM by the Firebird server process. If still intend to 
>> run with ClassicServer, then each connection spawns its own process, 
>> thus you probably won't hit the addressable RAM limit with Firebird
32-bit.
>> That might be different with Firebird SuperClassic (32-bit), because 
>> this is a single process architecture.
>>
>> I connect with odbc. Known Issues while migration,
>>> metadata etc. ?
>>
>> The usual path is creating a gbak-based backup with Firebird 2.1 and 
>> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you 
>> can check with gstat -h afterwards).
>>
>> On the client side, make sure that you are using a version of the 
>> Firebird client library matching the server version. Bitness (32-bit vs.
>> 64-bit) of the client library is driven by your application and not 
>> by the Firebird server. So, if you are application is 32-bit (Delphi
>> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>>
>> Hope this helps.
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird FB TraceManager, IB 
>> LogManager, Database Health Check, Tuning etc.
>>
>>
>> 
>>
>> 
>>
>> ++
>>
>> 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/
>>
>> ++
>> 
>>

Re: AW: AW: AW: [firebird-support] Architecture

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

> Yes, Thomas,
>
> it woks with 2.1. In the release notes of 2.5.X is written:
>
> Adding a value to a timestamp earlier than '16.11.1858 00:00:01' would throw
> the error "value exceeds the range for valid timestamp".
>
> But where can I search 200 Tables...

Read Paul's blog on using -v for the restore etc ...


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.


> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 17:07
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: AW: [firebird-support] Architecture
>
>> now, the switches works fine, I had forget the Charset -fix_fss_d
>> ISO8859_1
>>
>> It works fine, but there is another problem to fix. Now I get the
>> error, that value exceeds the range for valid timestamps. How can I fix
> this issue?
>
> * When does that happen during the restore?
> * Does a backup *AND* restore with Firebird 2.1 works?
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
> Database Health Check, Tuning etc.
>
>> I have installed fb as cs without superclassic under 32 Bit Win7 the
>> 32 Bit Version
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:51
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: AW: [firebird-support] Architecture
>>
>>> Thanks. For some Years, we have had in use the superserver, but since
>>> we have a quadcore CPU, we are using cs.
>>>
>>> UDFs can I replace with build in functions
>>
>> I guess you can imagine that you first need to do that before backing
>> up and restoring?
>>
>>> Now, I have restored the database with 2.5, but.. Errors :( Now I
>>> have seen the new switches -fix_fss_d and m, but now I get another
>>> error, no character set were found.
>>
>> * What is the character set of your database used when you have
>> created the database in the past?
>> * What is the exact error message?
>> * How did you install Firebird 2.5?
>>
>> Is there another way to migrate? With the scripts while
>>> running 2.1?
>>
>> backup/restore via gbak is the preferred solution, because it also
>> moves data. Of course, you still can create an empty Firebird 2.5
>> based database with a DDL script and then pump your data with a tool
>> from your source into the destination database.
>>
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird FB TraceManager, IB
>> LogManager, Database Health Check, Tuning etc.
>>
>>
>>
>>>
>>> thanks
>>>
>>> -Ursprüngliche Nachricht-
>>> Von: firebird-support@yahoogroups.com
>>> [mailto:firebird-support@yahoogroups.com]
>>> Gesendet: Freitag, 8. Januar 2016 16:37
>>> An: firebird-support@yahoogroups.com
>>> Betreff: Re: [firebird-support] Architecture
>>>
>>> Hello Olaf,
>>>
 Hello,

 I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
 Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit
 installation of Firebird too?
>>>
>>> From an operational POV, a main factor with moving from 32-bit to
>>> 64-bit is if you are using (third-party) UDF libraries. You need them
>>> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>>>
>>> Other than that, I guess it depends on your planned load, especially
>>> addressable RAM by the Firebird server process. If still intend to
>>> run with ClassicServer, then each connection spawns its own process,
>>> thus you probably won't hit the addressable RAM limit with Firebird
> 32-bit.
>>> That might be different with Firebird SuperClassic (32-bit), because
>>> this is a single process architecture.
>>>
>>> I connect with odbc. Known Issues while migration,
 metadata etc. ?
>>>
>>> The usual path is creating a gbak-based backup with Firebird 2.1 and
>>> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you
>>> can check with gstat -h afterwards).
>>>
>>> On the client side, make sure that you are using a version of the
>>> Firebird client library matching the server version. Bitness (32-bit vs.
>>> 64-bit) of the client library is driven by your application and not
>>> by the Firebird server. So, if you are application is 32-bit (Delphi
>>> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>>>
>>> Hope this helps.
>>>
>>> --
>>> With regards,
>>> Thomas Steinmaurer
>>> http://www.upscene.com/
>>>
>>> Professional Tools and Services for Firebird FB TraceManager, IB
>>> LogManager, Database Health Check, Tuning etc.
>>>
>>>
>>> 
>>>
>>> 
>>>
>>> 

AW: AW: [firebird-support] Architecture

['checkmail' check_m...@satron.de [firebird-support]]

Hello,

now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1

It works fine, but there is another problem to fix. Now I get the error,
that value exceeds the range for valid timestamps. How can I fix this issue?

I have installed fb as cs without superclassic under 32 Bit Win7 the 32 Bit
Version

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 16:51
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] Architecture

> Thanks. For some Years, we have had in use the superserver, but since 
> we have a quadcore CPU, we are using cs.
>
> UDFs can I replace with build in functions

I guess you can imagine that you first need to do that before backing up and
restoring?

> Now, I have restored the database with 2.5, but.. Errors :( Now I have 
> seen the new switches -fix_fss_d and m, but now I get another error, 
> no character set were found.

* What is the character set of your database used when you have created the
database in the past?
* What is the exact error message?
* How did you install Firebird 2.5?

Is there another way to migrate? With the scripts while
> running 2.1?

backup/restore via gbak is the preferred solution, because it also moves
data. Of course, you still can create an empty Firebird 2.5 based database
with a DDL script and then pump your data with a tool from your source into
the destination database.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.



>
> thanks
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:37
> An: firebird-support@yahoogroups.com
> Betreff: Re: [firebird-support] Architecture
>
> Hello Olaf,
>
>> Hello,
>>
>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
>> installation of Firebird too?
>
>   From an operational POV, a main factor with moving from 32-bit to 
> 64-bit is if you are using (third-party) UDF libraries. You need them 
> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>
> Other than that, I guess it depends on your planned load, especially 
> addressable RAM by the Firebird server process. If still intend to run 
> with ClassicServer, then each connection spawns its own process, thus 
> you probably won't hit the addressable RAM limit with Firebird 32-bit.
> That might be different with Firebird SuperClassic (32-bit), because 
> this is a single process architecture.
>
> I connect with odbc. Known Issues while migration,
>> metadata etc. ?
>
> The usual path is creating a gbak-based backup with Firebird 2.1 and 
> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you can 
> check with gstat -h afterwards).
>
> On the client side, make sure that you are using a version of the 
> Firebird client library matching the server version. Bitness (32-bit vs.
> 64-bit) of the client library is driven by your application and not by 
> the Firebird server. So, if you are application is 32-bit (Delphi
> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>
> Hope this helps.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>
> 
>
> 
>
> ++
>
> 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
>
>
>
>
>
> 
> Posted by: "checkmail" 
> 
>
> ++
>
> 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
>
>
>








++

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 

Re: AW: AW: [firebird-support] Architecture

[Thomas Steinmaurer t...@iblogmanager.com [firebird-support]]

> now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1
>
> It works fine, but there is another problem to fix. Now I get the error,
> that value exceeds the range for valid timestamps. How can I fix this issue?

* When does that happen during the restore?
* Does a backup *AND* restore with Firebird 2.1 works?


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

> I have installed fb as cs without superclassic under 32 Bit Win7 the 32 Bit
> Version
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:51
> An: firebird-support@yahoogroups.com
> Betreff: Re: AW: [firebird-support] Architecture
>
>> Thanks. For some Years, we have had in use the superserver, but since
>> we have a quadcore CPU, we are using cs.
>>
>> UDFs can I replace with build in functions
>
> I guess you can imagine that you first need to do that before backing up and
> restoring?
>
>> Now, I have restored the database with 2.5, but.. Errors :( Now I have
>> seen the new switches -fix_fss_d and m, but now I get another error,
>> no character set were found.
>
> * What is the character set of your database used when you have created the
> database in the past?
> * What is the exact error message?
> * How did you install Firebird 2.5?
>
> Is there another way to migrate? With the scripts while
>> running 2.1?
>
> backup/restore via gbak is the preferred solution, because it also moves
> data. Of course, you still can create an empty Firebird 2.5 based database
> with a DDL script and then pump your data with a tool from your source into
> the destination database.
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
> Database Health Check, Tuning etc.
>
>
>
>>
>> thanks
>>
>> -Ursprüngliche Nachricht-
>> Von: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Freitag, 8. Januar 2016 16:37
>> An: firebird-support@yahoogroups.com
>> Betreff: Re: [firebird-support] Architecture
>>
>> Hello Olaf,
>>
>>> Hello,
>>>
>>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to
>>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit
>>> installation of Firebird too?
>>
>>From an operational POV, a main factor with moving from 32-bit to
>> 64-bit is if you are using (third-party) UDF libraries. You need them
>> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>>
>> Other than that, I guess it depends on your planned load, especially
>> addressable RAM by the Firebird server process. If still intend to run
>> with ClassicServer, then each connection spawns its own process, thus
>> you probably won't hit the addressable RAM limit with Firebird 32-bit.
>> That might be different with Firebird SuperClassic (32-bit), because
>> this is a single process architecture.
>>
>> I connect with odbc. Known Issues while migration,
>>> metadata etc. ?
>>
>> The usual path is creating a gbak-based backup with Firebird 2.1 and
>> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you can
>> check with gstat -h afterwards).
>>
>> On the client side, make sure that you are using a version of the
>> Firebird client library matching the server version. Bitness (32-bit vs.
>> 64-bit) of the client library is driven by your application and not by
>> the Firebird server. So, if you are application is 32-bit (Delphi
>> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>>
>> Hope this helps.
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>> Professional Tools and Services for Firebird FB TraceManager, IB
>> LogManager, Database Health Check, Tuning etc.
>>
>>
>> 
>>
>> 
>>
>> ++
>>
>> 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
>>
>>
>>
>>
>>
>> 
>> Posted by: "checkmail" 
>> 
>>
>> ++
>>
>> 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/
>>
>> 

AW: AW: [firebird-support] Architecture

['checkmail' check_m...@satron.de [firebird-support]]

200 Tables :( Looking for timestamps before '16.11.1858 00:00:01'

 

Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 17:01
An: firebird-support@yahoogroups.com
Betreff: AW: AW: [firebird-support] Architecture

 

  

Hello,

now, the switches works fine, I had forget the Charset -fix_fss_d ISO8859_1

It works fine, but there is another problem to fix. Now I get the error,
that value exceeds the range for valid timestamps. How can I fix this issue?

I have installed fb as cs without superclassic under 32 Bit Win7 the 32 Bit
Version

-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
 
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Freitag, 8. Januar 2016 16:51
An:  
firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] Architecture

> Thanks. For some Years, we have had in use the superserver, but since 
> we have a quadcore CPU, we are using cs.
>
> UDFs can I replace with build in functions

I guess you can imagine that you first need to do that before backing up and
restoring?

> Now, I have restored the database with 2.5, but.. Errors :( Now I have 
> seen the new switches -fix_fss_d and m, but now I get another error, 
> no character set were found.

* What is the character set of your database used when you have created the
database in the past?
* What is the exact error message?
* How did you install Firebird 2.5?

Is there another way to migrate? With the scripts while
> running 2.1?

backup/restore via gbak is the preferred solution, because it also moves
data. Of course, you still can create an empty Firebird 2.5 based database
with a DDL script and then pump your data with a tool from your source into
the destination database.

--
With regards,
Thomas Steinmaurer
  http://www.upscene.com/

Professional Tools and Services for Firebird FB TraceManager, IB LogManager,
Database Health Check, Tuning etc.

>
> thanks
>
> -Ursprüngliche Nachricht-
> Von: firebird-support@yahoogroups.com
 
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Freitag, 8. Januar 2016 16:37
> An:  
firebird-support@yahoogroups.com
> Betreff: Re: [firebird-support] Architecture
>
> Hello Olaf,
>
>> Hello,
>>
>> I plan an update of firebird 2.1 cs 32 Bit with 32 Bit Server OS to 
>> Firebird 2.5. Is there a 64 Bit OS recommend and a 64 Bit 
>> installation of Firebird too?
>
> From an operational POV, a main factor with moving from 32-bit to 
> 64-bit is if you are using (third-party) UDF libraries. You need them 
> to be compiled with a 64-bit compiler if you want to run Firebird 64-bit.
>
> Other than that, I guess it depends on your planned load, especially 
> addressable RAM by the Firebird server process. If still intend to run 
> with ClassicServer, then each connection spawns its own process, thus 
> you probably won't hit the addressable RAM limit with Firebird 32-bit.
> That might be different with Firebird SuperClassic (32-bit), because 
> this is a single process architecture.
>
> I connect with odbc. Known Issues while migration,
>> metadata etc. ?
>
> The usual path is creating a gbak-based backup with Firebird 2.1 and 
> restore it under Firebird 2.5. The resulting ODS will be 11.2 (you can 
> check with gstat -h afterwards).
>
> On the client side, make sure that you are using a version of the 
> Firebird client library matching the server version. Bitness (32-bit vs.
> 64-bit) of the client library is driven by your application and not by 
> the Firebird server. So, if you are application is 32-bit (Delphi
> 32-bit?) use a Firebird 32-bit client library and ODBC driver.
>
> Hope this helps.
>
> --
> With regards,
> Thomas Steinmaurer
>   http://www.upscene.com/
>
> Professional Tools and Services for Firebird FB TraceManager, IB 
> LogManager, Database Health Check, Tuning etc.
>
>
> 
>
> 
>
> ++
>
> 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
>
>
>
>
>
> 
> Posted by: "checkmail" < 
check_m...@satron.de>
> 
>
> ++
>
> Visit   http://www.firebirdsql.org and click

Re: [firebird-support] Small Database with very very bad performance on LAN

[Luigi Siciliano luigi...@tiscalinet.it [firebird-support]]

Hallo,

Il 08/01/2016 14.20, Daniel Rail dan...@accra.ca [firebird-support] ha 
scritto:



Have you tried with SuperClassic or Classic? SuperServer 2.5.5 still



Ok, I tried SC and CS and the performance on LAN seems best of SS but 
not good :( May be the performance of CS is best of SC but seems very 
similar.


With CS or SC the performance are too slow for working, seems the same 
like the SS


The same application with BDE (Borland DataBase engine) works fast even 
in LAN but the application with firebird is tool slow even contain the 
same data!


Any other suggestion?

Thanks

--

Luigi Siciliano
--

ODP: Re: [firebird-support] Need Support to connect to the database

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

hi,
by what software/driver do you try to connect. did you try connecting by 
isql?If you can not connect by isql then i suppose password was changed
regards,Karol Bieniaszewski

 Oryginalna wiadomość 
Od: "Jianbo Li l...@stunningtech.com [firebird-support]" 
 
Data: 08.01.2016  02:54  (GMT+01:00) 
Do: firebird-support@yahoogroups.com 
Temat: Re: [firebird-support] Need Support to connect to the database 


 



  



  
  
  
  
  
Hi Zoran,



Thanks for you reply,



I have checked the fbclient.dll file, it is x32 and my OS is windows
7 x32.



Do you have any other ideas on this problem?



Thanks,



Jianbo



At 2016/1/7 21:31, 'Zoran'
  zoran...@gmail.com [firebird-support]:


  
  
  

  Check
  if fbclient.dll is has the right bitness (x32 or x64).
   
   
  

  From:
  firebird-support@yahoogroups.com
  [mailto:firebird-support@yahoogroups.com] 

  Sent: Wednesday, January 6, 2016 8:50 PM

  To: firebird-support@yahoogroups.com

  Cc: Rees Theo
  

  Subject: [firebird-support] Need Support to
  connect to the database

  
   
    
  

  
 

  Hi,



I'm working on a project that need to connect to
the database file, but I got an error message,



"Statement failed, SQLCODE = -902

  Your user name and password are not defined.
  Ask your database administrator to set up a
  Firebird login."



The database file is used in an application
named GP Complete, I have asked the owner, he
told me that I may need to ask support from
Firebird, he didn't change the default password
"sysdba/masterkey".



Could anyone let me know how can I connect to
the database file?



Thanks