[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
no is not a problem of memory usage. If i close the connection after 1 insert , then reopen the DB and keep inserting i do not have the memory error i use FIREDAC and DELPHIXE7 i am not sure if is a question of buffering on the FIREDAC libraries i've opened a ticket to the FIREDAC support to check for it it seems that also DBEXPRESS drivers have the same issue if you are making a continuos insert (around 1 records) this is not a real application i wanted only to check sizes i have also another issue if i try to install FB64 on a W2008 server i have a big performance issue it is a DC controller, and i know all the story about it so i have insalled the DB in a separated virtual disk where is already installed also Exchange i've tried to install both Classic, and superserver but to save a blob with a 10 mb of image in a simple table i need around 9 seconds, that seems too much
Odp: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test
Hi, Can you provide source code with this insert action / also dfm I have Xe7 and i can test this About FB on DC this is one hell with Exchange. And it is much bigger problem if you have older version of FB then 2.5.3 (may be 2.5.2 fix i do not remember) on Win2008 with bigger then 4GB RAM Regards, Karol Bieniaszewski - Reply message - Od: af_12...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test Data: wt., gru 16, 2014 12:27 no is not a problem of memory usage.If i close the connection after 1 insert , then reopen the DB and keep inserting i do not have the memory error i use FIREDAC and DELPHIXE7 i am not sure if is a question of buffering on the FIREDAC librariesi've opened a ticket to the FIREDAC support to check for it it seems that also DBEXPRESS drivers have the same issue if you are making a continuos insert (around 1 records)this is not a real application i wanted only to check sizes i have also another issue if i try to install FB64 on a W2008 server i have a big performance issueit is a DC controller, and i know all the story about it so i have insalled the DB in a separated virtual disk where is already installed also Exchangei've tried to install both Classic, and superserver but to save a blob with a 10 mb of image in a simple table i need around 9 seconds, that seems too much
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
No Regards, Vlad ---In firebird-support@yahoogroups.com, af_123xy@... wrote : out of memory inserting the Blob is there any difference betwern 32 and 64 FB engine about db size limit (supposing that i am on a NTFs (5) filesystem) ?
Odp: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test
Hi, Do you use firedac cached updates? I suppose that problem is not Fb. What happened when you close your app and continue inserting? Db process this data or still 2GB limit? Regards, Karol Bieniaszewski - Reply message - Od: af_12...@yahoo.com [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Re: FB 2.5.3 32bit and Db size limits test Data: sob., gru 13, 2014 17:10 I don't remember what type of installation I didis there any way tto check if it is SS , classic etc? i have page size 16384page buffers 0i cant see any info about cache as you say then i had a problem somewhere becouse u used FB32 with 20gb ..i dont have a full application just i made a test to save simple blob for check the size the strang thing is the to aovid the out of memory error disappeared when i installed on the same machine FB64 and could save more images just speciginh in FIREDAC the vendorlib option dll
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
out of memory inserting the Blob is there any difference betwern 32 and 64 FB engine about db size limit (supposing that i am on a NTFs (5) filesystem) ?
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
to don't give public access to a fileystem folder to any user that needed to read/write the images
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
I don't remember what type of installation I did is there any way tto check if it is SS , classic etc? i have page size 16384 page buffers 0 i cant see any info about cache as you say then i had a problem somewhere becouse u used FB32 with 20gb .. i dont have a full application just i made a test to save simple blob for check the size the strang thing is the to aovid the out of memory error disappeared when i installed on the same machine FB64 and could save more images just speciginh in FIREDAC the vendorlib option dll
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
Hi i suppose Classic becouse i forgot now which one i took at installation is there a way to check what version classic SS etc ? page size is 16384 page buffers is 0 i dont see any cache specification in gstat i had not a full application i just made a small tool with delphi Xe7 and Firedac to access the db and insert the image as you are telling me that you were using FB 32 bit and have a 20gb i shuold suppose that i had something wrong on my application what is strange is thatn when i installed the 64 bit engine on the sam app i didnt got the error i had win7 64 bit on both test, first was FB32 stoped at 2gb size then i installed the 64 and i could get more
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
On 13 Dec 2014 08:30:54 -0800, af_12...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: i had win7 64 bit on both test, first was FB32 stoped at 2gb size then i installed the 64 and i could get more What is memory use of 32 bit, when error occurs. Sounds like you are leaking query handles, which causes Firebird to hit 2 GB memory limit for 32 bit processes (unless 32 bit Firebird is IMAGE_FILE_LARGE_ADDRESS_AWARE set - in which case the limit under 64 bit Windows would be 4 GB). And could you monitor memory use of 64 bit Firebird during the same test. -- Virgo Pärna virgo.pa...@mail.ee
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
Alex, what is limit of 2.083.888 kb ? Is it size of database file on disk ? Is it memory usage by Firebird process (what exact memory counter) ? Something else ? How do you insert blobs into database ? Regards, Vlad ---In firebird-support@yahoogroups.com, af_123xy@... wrote : Hi all i am new user of FB and i am making a tests to check a one db size limits to see if i can choose FB to support a new application. i will need to acquire in the DB only blob types to save images, jpg, pdf, tiff , etc of different dimension so i made a small application test on a W7/64 bit and FB 32bit and after reaching almost 13.000 images and reached a limit of 2.083.888 kb i've go an out of memory message inserting one more Blob record i were reading on the official website that on some Platform the size limit is some terabytes a part some limit imposed by filesystem do i should use FB 64 bit version for handle it or i am doing something wrong in the configuration? thank you for any suggestions Alex
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
Off topic, what is the benefit of storing the images actually in the database?
[firebird-support] Re: FB 2.5.3 32bit and Db size limits test
with 64bit I could reach 4gb ops i forgot to tell that i use FIREDAC and XE7 i tought i could get much bigger db!!!