Re: [firebird-support] Database 'conversion'
Guten Tag Lester Caine les...@lsces.uk [firebird-support], Strings with charset none need only 1 byte per char in the receive buffer of your software UFT-8 will reserve 4 Bytes per char , regardless if it is needed or not , this can cause some problems on larger records > For 20 odd years I've only ever created databases with a charset of NONE > and because of the way PHP works the odd UTF8 string just works as raw > data. Strange names and address strings just work and there is normally > only a problem when the string was corrupt anyway. > Now I think it's time I started to look at tidying things up, and move > to UTF8 as the default character set. I've various notes across several > versions of FB, but is there a good current crib sheet on how to handle > this? I think I'm simply looking at creating a new empty UTF8 copy of > the database and pumping over from the NONE version? > I'm just trying to decide if it's worth upgrading ibWebAdmin to handle > the transfer so I can play with csv dumps and pick up some other raw > data sources, but are there other tools working with FB3. I'm find a > number of the tools like XMLWizard are being blocked by my ISP but I > think they are the same versions as I downloaded some time ago but which > will not run on my current version of SUSE :( -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?
Guten Tag Dalton Calford dalton.calf...@gmail.com [firebird-support], there is a free but limited version of ibexpert available which supports all current firebird versions http://www.ibexpert.net/ibe/ IBExpert Developer Studio Personal Edition > All the free firebird management tools are falling by the wayside. > Flamerobin can not handle the new datatypes, does not show database triggers, > crashes with UTF8 in many areas etc. > FenixSQL is dead > FirebirdWebAdmin is based on the no longer supported php5 > the list goes on. > Dbeaver is generic and is not well suited for Firebird > Overall, the loss of all these free administration tools stops people from > attempting to try firebird. > On Fri, 9 Nov 2018 at 09:49, jonatan.laurit...@yahoo.dk [firebird-support] > wrote: > > > > > > OK, there are multiple error reports in Flamerobin trackers about this and no > solution in more than 1.5 years. Flamerobin 9.2 works as expected, although > it does not support > internal functions, but such feature is not necesary for script execution.. > Apparently, Flamerobin is ceasing to exist. > DBveaver can be good replacement, but it has different convention for > scripts, e.g., it does not support multiple commit work; statements in the > script. > > > > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Read only transaccions and generators
Guten Tag Aldo Caruso aldo.car...@argencasas.com [firebird-support], Generators/Sequences operate outside of transactions , so: yes. > Hello, > I discovered that a read only transaction can increment a generator. > Is that right ? > Thanks > Aldo > > Posted by: Aldo Caruso > > ++ > 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 -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Charset UTF8 or ISO8859_1 for new DB with CI + AI
Guten Tag r...@seedsbydesign.com [firebird-support], > Here are my questions: > 1. Is only one byte used for storage for english and spanish? NO plain englisch will still be one Byte but spanisch (the accented n ) will be multiple bytes > 3. Is there any downside to using UTF8 and UNICODE_AI_CI over ISO8859_1 and > collation ISO8859_1? UTF8 will always reserve 4 bytes per "Char" in Transferbuffers because a UTF8 Char can be up to 4 Bytes long if have not looked at FB 3 but in 2.5 the maximum size of a varchar is some 32000 Char , due to the 4 Byte/Char space reservation mechanism this will go down to 8000 and some for UTF8 Encoded > Regards, > Rick > > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar
Guten Tag ""Köditz, on another list if have read the following comment on a similar question integers are compared as integers, one operation strings are compared on a per characters basis so changing your integer into a length 10 string would mean 10 comparisons instead of one but i definetly would like to read an answer from someone wo is more into the depth of firebird internals > > > > > Hi, > > > > I’m using integer IDs for primary keys in my tables. What if I > would use varchar fields instead? Will I lose performance in that > case, especially for big tables? Will joins still work as fast as they do for > the integer column. > > > > In my case I have a table TBL_BANK ( > > BANK_ID int, > > BIC varchar(11), > > … > > ) > > > > So what will happen if I switch the PK to BIC in that case? I would > change the FKs to BIC too. I don’t know how the index keys are build > and stored in firebird. So I cannot say this way is faster than the > other one. But maybe someone else can do. > > > > Regards > > Martin > > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Re: Bad surprise on performance
Guten Tag André Knappstein knappst...@beta-eigenheim.de [firebird-support], am Samstag, 3. Januar 2015 um 10:45 schrieben Sie: > Stripe size is 64K, btw. much too big , best size for a stripset ist same as DB Page Size Strip Set 64Kb means that the controller will read and write Blocks of 64KB each I/O operation with a page size of 4 KB 60 KB are moved around with no use , wasting more then 90 percent of the disk read/write bandwidth (disk caches will reduce the impact somewhat) my LSI Controller allows me a stripeset as small as 16kb , so it set my page size to match -- Mit freundlichen Grüssen/ wbr Hannes Streicher
Re: [firebird-support] FB 2.5.3 32bit and Db size limits test
Guten Tag af_12...@yahoo.com [firebird-support], what is the filesystem used ? > 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? -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2
Guten Tag 'Costantino Molinari' c.molin...@tiscali.it [firebird-support], > To Karol: > Original page size was 16K, than I changed page size to 4K just > as my NTFS cluster size and time incredibly doubled !! > Really confused, but maybe it has to do with the 64K stripe size > of RAID 10…. Not surprisiing at all, Stripe Set is the amount of Data a RAID moves for every read/write so if you have 16 KB or 4KB you still move 64KB each time but with much less usable Payload per transfer go for a Stripsetsize of 16 KB and a Pagesize of 16KB for best match -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de ++ 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] Invoice Detail: Design / Normalization
Guten Tag shg_siste...@yahoo.com.ar [firebird-support], i do it that way, store all information in the Invoice, because my experience is Data changes changing your Item Description would change your Invoice which would get you in trouble with Tax Authorities as an alternative you could "Version" your description and link to the correct Version > It's a design / normalization question: How to save Invoice detail correctly? > Each line on the invoice detail has its FK pointing to the Article's ID, but > sometimes the user needs to modify or add some text to the article > description just for that > invoice. Or sometimes he/she needs to insert a "free" line (pointing to no > article at all) just filling the description. > So my "big" doubt is: Is this a case for "denormalization" ? Should I add a > "description" field to the invoice detail (and 90% of the time having exactly > the same description of the article's table!!) > Or should I have the "description" field in a separate table. In this case I > don't imagine how to update that table, as the user enters the data in a > DBGrid (I work with Delphi / IBDac) > I hope I'm clear with my question! > Thanks! > > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server
Guten Tag halim1...@yahoo.com [firebird-support], much too few information for any reasonable answer, so just the standart Cache settings ? ar way too low in staddart classic setup try increasing them > Hello All, > Our database is about 30 GB. We are using Firebird 1.5. When restoring the > database using Super server install, the restore takes about 2.5 Hours but > when we use Classic Server mode, the restore takes over 8 hours. > Our machine is up to date as far as CPU and RAM(64 GB ). > Any idea why this difference of restore speed? > Thank you, > -Halim > > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Firebird - Any way to query between databases
Guten Tag craig_...@coxcolvin.com, there is someting called external tables that could fit your requirement however i dont think that this will work if they are accessed from multiple databases concurrently > I have a growing number of databases with essentially the same table > structures that must remain as separate entities. However, a large number of > the tables in these > databases house exactly the same valid values (Lookup Tables). If I add a > new valid value, I migrate through each database to update the tables as > needed. I would love to have > a single valid value database that only held these tables and have all my > other databases query the valid value database for the information. As I > understand it, this is not > possible at this point in time. Are there any plans that will permit this in > future versions of Firebird? > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hello Jesus Garcia, > Then, If it were only a firebird issue, all of us would have the problem. > If some of us has the problem, may be an incompatibility between FB, OS and > hardware. > Perhaps, if we share information about our environments, the common origin of > the problem would arise. > Jesus Angel Garcia Zarco > Cointec and here is a nice list of information to provide http://ib-aid.com/articles/item157 -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Required information for Firebird database performance optimization
Guten Tag Alexey Kovyazin, nice Questionaire , i would suggest to add 1 more point if it has a Raid then the size of the Stripe Set The Stripe Set ist the amount of data a raid moves to / from the diskarray for every read/write. Example: a Raid 5 with 3 Disks and a Stripset of 128 KB means that each Read / Write will move 192 KB now add a Database Page Size of 4 KB (Worst Case) then every database page read or written will instead move 192 Kb or a 48 fold overhead > Hi All, > I am a bit tired of repeated topics regarding database performance, so I > decided to publish short version of our performance questionnaire: > http://ib-aid.com/articles/item157 > I suggest to always ask people who come here with Firebird performance > problems to answer these questions and send answers to the list, in > order to facilitate performance problems resolution. > Regards, > Alexey Kovyazin > IBSurgeon > > ++ > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > Also search the knowledgebases at http://www.ibphoenix.com > ++ > Yahoo Groups Links -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Guten Tag Roland Turcan, a large Raid Stripe Set can be a real showstopper for Databases what are your settings for Database Page Size and for the Raid What Type of Raid 1,5,10 Size of the Stripe Set > Hello guys, > I found some info about problems with performance when FB is running > on Win2008R2 which is domain controller. > But in my case is it not DC, but the performance is the worst I met. > It is new server running 10GB of RAM, RAID, ... it is quite new > server box. > It cannot be, that basically dummy update on table with about 700 000 > records is executing over one hour. CPU is relaxing, HDD is relaxing > too and I cannot force server to fun faster. > What can I check? > Thanks in advance. -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Error Not Enough Disk Space
Guten Tag trsk...@yahoo.com, FAT32 is limited to 4GB Files this is your problem > I have a strange error message, tell me that there is not enough disk space > while actually it is enough space. > Here are the environment : > - database size is 4 GB, running on RAM Disk formatted as FAT32, free space > still 4 GB > - Firebird Super Classic 2.5.2 64 bit > - Windows 7 64 bit with 16 GB memory > Is that because database running on RAM, but there is still a lot of free > space? > Testing and running database on physical disk seem ok, but it is very slow > since don't have rapid harddisk. -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] FW and Journaling
Guten Tag Andrea Raimondi, Journaling will only save what is written to disk, Forced Writes will make sure it gets written, so if your computer crashes journaling will leave you with a broken database > > I would always go for journalling on, it is in my opinion safer overall. > A > On Sat, Sep 28, 2013 at 3:23 PM, Carlos H. Cantu > wrote: > > It is well known that the writing performance of FB databases on > linux, when you have Forced Writes ON and the filesystem has the > journaling parameter active is horrible and almost unusable if you > have lots of writing (or even worse, massive/batch updates). > > Question is: > > What would be safer: > > Keep FW OFF and Journaling ON > or > Keep FW ON and Journaling OFF > ? > > []s > Carlos > Firebird Performance in Detail - http://videos.firebirddevelopersday.com > www.firebirdnews.org - www.FireBase.com.br > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++ > Yahoo! Groups Links > > > > -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Re: How to maximize cpu usage for Firebird?
Hello trskopo, you are using a 4 Core CPU , with Multithreading , so it has 8 Virtual cores 16% means that you are using 1 Core to the maxmimum Try running several Queries from different connections on classic server then you will use more cores Super Classic will Use 1 Core per Database , so that is all you get for your setup Super Classic will only benefit you if you have several Databases > --- In firebird-support@yahoogroups.com, Alexandre Benson Smith > wrote: >> >> Perhaps the bottleneck is not the CPU, maybe your disk subsystem can't >> provide information as fast as the CPU can process it. I think your CPU >> is sitting idle while waiting the disc provides the data. >> I/O bound x CPU bound process... >> see you ! > Thanks for your reply. > My database is on RAM, as I know it is the most fastest I/O for Firebird. > I was watching cpu's utilization via window's task manager, almost constantly > at 16%. > If there was a bottleneck in I/O, whenever I/O processing finished, I should > saw some raising in cpu's utilization. > I though this was no bottleneck, it just seems that FB Server couldn't > utilized more power from cpu. > Anto > > ++ > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > Also search the knowledgebases at http://www.ibphoenix.com > ++++++++++ > Yahoo! Groups Links -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Error dropping index after col rename - (known) bug?
Guten Tag Kjell Rilbe, what happens if you commit after alter table ? > Hi, > This seems buggy to me (Firebird WI-V2.5.2.26540 64 bit): > create table "Test" ("MyCol" int); > create index "IxTest" on "Test" ("MyCol"); > [commit] > alter table "Test" alter "MyCol" to "NewName"; > drop index "IxTest"; > [commit] > In FlameRobin, this results in error message: > == > *** IBPP::SQLException *** > Context: Transaction::Commit > SQL Message : -607 > This operation is not defined for system tables. > Engine Code: 335544351 > Engine Message : > unsuccessful metadata update > cannot create index IxTest > == > After that, the index seems to be in use preventing me from doing > "anything", until I disconnect and reconnect. > If I drop the index before renaming the column, it works as expected. -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Fuzzy match on business name
Hello All, >> Here's one I hope others have encountered (and possibly found an elegant >> solution). >> ... SNIP ... >> constituent's last name (in uppercase). It works well for individuals, >> but fails to catch my 'Corlis Estates' example above. Yes, I could break >> the incoming business name string into individual words, eliminate the >> common "The, A, An, The, Inc,..." and submit individual words in a chain >> of "or"s. Has anybody got a better way? >> >> Lane C. >> NW Software > I would be thinking of a SOUNDEX function for this. I need one myself to > ensure that the "fat fingered" user - me - of my Music collection can > type in a name that's roughly spelt correctly. > The Soundex for Jon, John, Johanne etc all boil down to J500, so I would > go in to the soundex table looking for the J500 and from that, pull out > the artist PK id (1) and joing on that to the Atrist table to get my > match/matches. Soundex has the advantage over other algorithms that the value to be compared can be precomputet and stored in the DB and the disadvantage that the FIRST Letter is fixed another option , which however needs on the fly calculation during the database search would be levenstein which gives a numeric value how close two words are -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Re: Unable to INSERT INTO TABLE
Guten Tag Alexandre Benson Smith, > Em 15/5/2013 16:35, Allstars escreveu: >> Ok sorry, now I am getting a different error. When I do the insert, >> >> I'm getting a >> >> Error: arithmetic exception, numeric overflow, or string truncation >> string right truncation >> >> What does that mean? Thanks! >> > If I read you example correctly you are trying to insert an empty string > ('') into a int column. a) no he is using an empty fieldname b) if it were mysql then insert into table (intfield) values (''); does aktually work producing a null ( if not in strict mode) -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] What is the maximum number of lines an SQL statement can have in FB 1.5 and 2.5
Guten Tag Thomas Steinmaurer, >> I have an application that builds dynamic queries for users as they progress >> through a series of forms and choose items to include. The query is then >> fed to and FB 1.5 database. >> >> I have a situation where the SQL statement causes an error, even though >> there does not appear to be anything wrong with the data, table structures, >> or SQL syntax. >> >> For instance, a statement that runs correctly contains 1214 lines. One that >> crashes has 1362 lines. >> >> If there is a limit in FB 1.5, does FB 2.5 have the same limit? > Yes. ~64K for both. 64k Characters :) not lines -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: RES: [firebird-support] Copy of the current db not updating generators
Hello Tupy... nambá, what is the setting of forced writes because generators are outside of transaction control and thf shud be updated immediately > Thanks, Mark. This is exactly what I needed to know. > > We know about the risks making copies this way, but this is done by another > person, not by ourselves. Since there is a minimal chance of having troubles, > certainly they will > happen (see Murphy laws). But dividing responsabilities, each one is > responsible for their working manner. > > As you say, I infer that the way the copies are given us is the "guilty", the > causer for not having the generators updated, ok ? > --- On Thu, 5/31/12, Mark Rotteveel wrote: > From: Mark Rotteveel >> Then I ask = restoring the db will put the generators in the updated >> status ? > I am not sure what the problem is your having. Making a backup of > production and restoring it in your dev-environment, will set everything in > the database as it was at the time the backup was created including > generators. If you mean something else, please explain what you mean. > Mark -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Multiple instances
Guten Tag Jesús García, and use different Port Numbers > El 23/01/2012, a las 12:00, "bennie_coetzer" > escribió: >> If I run multiple instances of FB, where are the different firebird.conf >> files saved? >> Bennie >> >> > I think You have to install Firebird in a different folder for each instance, > with its own Firebird.conf -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Performance in Firebird 2.5
hello Mahesh Pratihari, check your Transaction Handling > Hi ALL, > > Could you please let me know how I can do with the Performance in > Firebird 2.5? > > Application is getting slower and slower as data is entered. > > > Thanks, > Mahesh Pratihari > Sonata Software Limited > Phone : +91 80 3097 1570 > Mobile : +91 99808 37446 > www.sonata-software.com > > Please don't print this email unless you really need to. This will > preserve trees on our planet. > > [Non-text portions of this message have been removed] > > ++ > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > Also search the knowledgebases at http://www.ibphoenix.com > ++++++++++ > Yahoo! Groups Links -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Database file remains locked when connection is closed
Guten Tag psylencedave, > I have the following code to create a database in C#, but the application > doesn't release the database file when the connection is closed. What am I > doing wrong? > public class FirebirdDatabase > { > FbConnection connection; > public void CreateDatabase() > { > try > { > FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); > cs.Database = "C:\TestDb.GDB"; > cs.UserID = "SYSDBA"; > cs.Password = "masterkey"; > FbConnection.CreateDatabase(cs.ToString(), true); > this.connection = new FbConnection(cs.ToString()); > this.connection.Open(); > this.connection.Close();//doesn't release DB file > this.connection.Dispose(); //doesn't release DB file > File.Delete(cs.Database); //fails here! > } > catch > { > } > } > } > Full error message: > Code: > The process cannot access the file 'C:\TestDb.GDB' because it is being used > by another process probably the file remains locked due to some internal housekeeping of the Database Engine going on after disconection ( Sweep , garbage collection) wait a while before trying to delete the file -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
Re: [firebird-support] Re: FB database in RAM
Guten Tag Lester Caine, am Freitag, 5. August 2011 um 10:50 schrieben Sie: > A thought just popped up ... with some fairly simple replication, the 'active' > database might be able to 'insert' into the read only? If we are only adding > to > the end of a list controlled by a generator sourced ID then the indexes > should > just 'insert' at the end? But of cause I'm forgetting that we need to update there is no "Insert to the end of an Index" Index will be rebalanced every now and then upon an insert/update/delete which can will likely produce a lot of writes wenn looking at SSDs look at the Manufacturers Specification for TBW "Terra Bytes Written" that should give a way to compare the different Modells and select the one best suited , if any -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de