Loading ...
Sorry, an error occurred while loading the content.
124415
Re: Odp: [firebird-support] Request for advice Good morning Karol, yes, storing big data chunks outside database file is an opinion we regularly use, too. It has the serious disadvantage, that you've to
Thomas Beckmann
10:02 PM
#124415
 
124414
Odp: [firebird-support] Request for advice Hi, But you also misunderstud advice. Blobs are not stored in table with its other fields. In record exists only blob id and blob is stored on separate pages.
liviuslivius@...
9:31 PM
#124414
 
124413
Re: Request for advice As I fear, some people misunderstood Frank's hints, I'd like to clarify: I know no reason to store blobs in data table with other objects data, it should be
Thomas Beckmann
3:47 PM
#124413
 
Fetching Sponsored Content...
124412
Re: Request for advice ... If the blob's are small enough to fit into the data page, it will dramatically reduce the number of records per page, and ever if you don't select it you
Alexandre Benson Smith
3:29 PM
#124412
 
124411
Additional Table Permissions Needed by Update in Stored Procedure Firebird Version: 2.5.2.26540 OS: Windows 7 I'm having an update permissions problem on a SQL update statement when I use the SQL in a stored procedure with
pvmalone@...
2:49 PM
#124411
 
124410
Re: Request for advice ... As most blobs are stored out of band, I would expect that moving them to a separate table this doesn't have a big impact unless you have the habit of
Mark Rotteveel
1:08 PM
#124410
 
124409
Re: Request for advice ... As a compromise, I would suggest to place your blobs into a separate table, it will increase the size of your main database, but will also speed up the
Frank Schlottmann-Gödde
11:49 AM
#124409
 
124408
Re: Request for advice Thanks Thomas. Blobs are seldom accessed. Much appreciated. Mags On Thu, Apr 24, 2014 at 11:32 AM, Thomas Beckmann < ... Thanks Thomas. Blobs are seldom
Mags Phangisa
4:32 AM
#124408
 
124407
Re: Request for advice Hi Mags, my experience says "it depends"... I don't feel big databases beeing significantly slower than smaller ones, and the overhead of accessing the blobs
Thomas Beckmann
2:32 AM
#124407
 
124406
Request for advice Is it more advantageous, speed-wise, to split a database into two, i.e. one database for data and another one just for attachments? Regards, Mags
Mags Phangisa
2:25 AM
#124406
 
124405
Re: flamerobin access from client ... What do you mean by "set up a server connection"? The "\\server" element MUST be the host name of the actual server machine, not a mapped drive. There's
Helen Borrie
Apr 23
#124405
 
124404
Re: flamerobin access from client ... Try with the connection string: Server:c:\data\db.fdb _
Jesus Garcia
Apr 23
#124404
 
124403
flamerobin access from client I have a firebird (2.5) database being accessed by a custom application over a windows 7 network (32bit) The application works fine. The customer would also
LAByerly
Apr 23
#124403
 
124402
Re: Cannot log into database Thanks for your comments. Lots to learn here and your comments are a great help. I was able to resolve the issue overnight. I first backed up the 1.5 fdb file
srotyliano
Apr 23
#124402
 
124401
FB 2.5.2 SS crash Hi all, Today one of our client got these messages in the firebird.log: DBSERVER (Server) Wed Apr 23 09:07:15 2014 Access violation. The code attempted to
Zsazsi
Apr 23
#124401
 
Fetching Sponsored Content...
124400
Re: Cannot log into database ... So it is can connect to Firebird servers in different computers, but not the one running in the same computer? How exactly did you describe alias? What is
Virgo Pärna
Apr 23
#124400
 
124399
Transliteration of identifiers, query buffers etc? Hi, I've been wondering a bit about how Firebird handles transliteration of various parts of a query, in particular regarding (quoted) identifiers. My
Kjell Rilbe
Apr 23
#124399
 
124398
Grant and Revoke update (field) Hello, I have a problem with permissions. I test this problem on new database. I have two users (User1 and User2), one table (TEST_TABLE (PKID, NAME, AGE)). I
Tomáš Beran
Apr 23
#124398
 
124397
Re: Cannot log into database ... You are vague about what is where, e.g., is the client on a 64-bit or 32-bit system? For certain your application is 32-bit because any Delphi version
Helen Borrie
Apr 22
#124397
 
124396
Re: Cannot log into database ... Wow, BDE is still in business, even on Windows 7 64-bit. A few things I would check: * Which Firebird client library is loaded by the BDE? * Are you using
Thomas Steinmaurer
Apr 22
#124396
 
124395
Cannot log into database I don't know if this is Firebird or a BDE issue but I am trying to port a legacy client that runs on FB 1.5 from an XP system to a WIN7 (64 bit) system. I was
srotyliano
Apr 22
#124395
 
124394
Re: Efficient subselects ... Yes, I'll note this idea, I've got a similar query I'll probably have to speed up one day! -- Tim Ward
Tim Ward
Apr 22
#124394
 
124393
Re: Copy Table You are welcome... Happy Easter! Thomas ... -- Mit freundlichen Grüßen, Thomas Beckmann Diplom-Informatiker Wielandstraße 14c • 23558 Lübeck Tel +49 (22
Thomas Beckmann
Apr 21
#124393
 
124392
Re: Copy Table That's great Thomas ! Thank you very much for your effort, this is a nicely done/written procedure and that will do the job. (Sorry for my late reply)
ardatun
Apr 21
#124392
 
124391
Re: how to connect server from client Hi, getting error message I/O error during "CreateFile (open)" operation for file "C:\SampleDatabase.fdb" Error while trying to open file Thanks Sukhen Dass On
SUKHEN DASS
Apr 20
#124391
 
124390
Re: database gone after server reboot ... Perhaps a different client library gds32.dll/fbclient.dll is loaded? Are you running InterBase and Firebird in parallel on the same machine? -- With
Thomas Steinmaurer
Apr 18
#124390
 
124389
Re: Is there any benefit when using Firebird Classic in 64bit versio ... In general, they are wrong. ;-) ... High RAM utilization doesn't necessary result in best performance. Usually, already with some conservative base
Thomas Steinmaurer
Apr 18
#124389
 
Fetching Sponsored Content...
124388
Re: Is there any benefit when using Firebird Classic in 64bit versio Thanks, I've read the article. Unfortunatelly it is irrelevant to my question, because I asked specifically about FB Classic and tests were conducted on
un_spoken
Apr 18
#124388
 
124387
Re: Is there any benefit when using Firebird Classic in 64bit versio In the real field 64 makes more sense here is one of the firebird customers comparing x32 vs x64 and they really benefit from 64 bit version speedup
jimi_compot
Apr 18
#124387
 
124386
Re: Is there any benefit when using Firebird Classic in 64bit versio ... Classic ... I don't think using 64 bit with classic adds a lot, however sometimes dependency- and management-wise having all 64 bit libraries on a 64 bit
Mark Rotteveel
Apr 18
#124386
 
View First Topic Go to View Last Topic
Loading 1 - 30 of total 124,415 messages