Loading ...
Sorry, an error occurred while loading the content.

Messages List

126787

Re: Firebird 2.5.x slow queries problem

On 2015-05-20 o 10:51, Sylvain Mazaudier smazaudi@... ... It's been a couple of days without any answer to this, so even though I feel I'm not the most
Tomasz Tyrakowski
2:14 AM
#126787
 
126786

Re: FB 1.5 server sluggish after been up for awhile

Hello, ... That's usually related to bad client transaction management. Once the database starts to become slow, run gstat -h on the database and check out the
Thomas Steinmaurer
1:54 AM
#126786
 
126785

FB 1.5 server sluggish after been up for awhile

Hello All, we are still on FB 1.5 release, our live Database is about 50 GB. While using the freshly restored database, things are very fast in the beginning
halim1973
May 23
#126785
 
126784

Re: GBAK - validation error for column X, value "*** null ***"

If you only have a backup and the backup is corrupted then .... very bad news. The best politic is always to do a backup/restore cycle inmediatly. So, if an
Walter R. Ojeda Valiente
May 23
#126784
 
126783

firebird.log contents

Hi this is from firebird 2.1.5, centos 5. I've never seen these messages before, anyone? myserver Sun May 10 20:30:18 2015 INET/inet_error: read errno = 104
Nick Upson
May 21
#126783
 
126782

Re: Advice requested on design pattern

You welcone :) A few points: 1) Re the separate database: nobody said you shouild do it from your own. I'd do it in the client, once the original data has been
Andrea Raimondi
May 20
#126782
 
126781

Re: Advice requested on design pattern

... I did not read it in full details... But the case of select on views be able to use the index on the first table I believe that's because of using of outer
Alexandre Benson Smith
May 20
#126781
 
126780

Re: Advice requested on design pattern

Thank you for your reply! On 20/05/15 11:12, Andrea Raimondi andrea.raimondi@... ... I am not anticipating there to be many blobs and they are only in a
Mike Ro
May 20
#126780
 
126779

Re: Advice requested on design pattern

Thank you for your response. On 20/05/15 11:25, Alan J Davies Alan.Davies@... ... In this way wouldn't the SP have the same problem that was
Mike Ro
May 20
#126779
 
126778

Re: Advice requested on design pattern

Another way of doing what you want would be to use SPs instead of Views. Then if you "select * from SP" and hide it as below, no-one can see what you are doing
Alan J Davies
May 20
#126778
 
126777

Re: Advice requested on design pattern

Hi! Here are my opinions; please feel free to point out any inaccuracies. On Tue, May 19, 2015 at 11:35 PM, Mike Ro miker169@... ... I think it really
Andrea Raimondi
May 20
#126777
 
126776

Re: Advice requested on design pattern

Thank you for this very useful response. On 20/05/2015 08:17, 'Louis van Alphen' louis@... ... Ah, this is very valuable. I will take your advice. ...
Mike Ro
May 20
#126776
 
126775

Firebird 2.5.x slow queries problem

Hello. We have a problem under Firebird 2.5.x. If a remote client connects to a server over a network with low flow , we have delays on requests . After having
Sylvain Mazaudier
May 20
#126775
 
126774

Re: Advice requested on design pattern

Q1: We have an application with around 400 table and we use this structure for all tables. I.e. apart from the payload columns, all tables have these
Louis van Alphen
May 20
#126774
 
126773

Re: Query to update multiple records in same Table

Thank you for the response Tomasz The query works like a charm! It is simpler & faster than the one I came up with & faster Update analog a Set a.Name =
millsjack14
May 20
#126773
 
View First Topic Go to View Last Topic
Loading 1 - 15 of total 126,787 messages