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

On Fri, Oct 2, 2015 at 5:09 PM, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > > > 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

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

Re: [firebird-support] Firebird 2.5 64 bit and UDFs not loading

On 1-10-2015 13:51, kerry.neighb...@yahoo.com.au [firebird-support] wrote: > > > I have been running Firebird 2.5 (32 bit) for sometime - in Windows 7 64 > bit. I use one of my own UDFs and FreeAdhocUDF for a lot of my queries. > > I am now trying to get Firebird 64 bit Super Server to work. The

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

At 10:09 a.m. 3/10/2015, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > >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