Re: [firebird-support] Database 'conversion'

2019-05-11 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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

Re: [firebird-support] Re: Anyone using latest Flamerobin (0.9.3) with Firebird 3.0.4 UTF8 database?

2018-11-09 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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

Re: [firebird-support] Read only transaccions and generators

2017-03-14 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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 >

Re: [firebird-support] Charset UTF8 or ISO8859_1 for new DB with CI + AI

2015-12-08 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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

Re: [firebird-support] AW: Performance comparision for primary keys - int vs. varchar

2015-10-03 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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

Re: [firebird-support] Re: Bad surprise on performance

2015-01-03 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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

Re: [firebird-support] FB 2.5.3 32bit and Db size limits test

2014-12-10 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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,

Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2

2014-09-29 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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

Re: [firebird-support] Invoice Detail: Design / Normalization

2014-09-24 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-24 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
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