Re: [firebird-support] performance on calculated fields - performance question

2015-04-29 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 29/04/15 21:40, shg_siste...@yahoo.com.ar [firebird-support] wrote: With 40.000 records, I have no problem with this. But do you think it will be very bad as the customers keep growing? I mean, generally speaking, it's expensive (regarding to the speed) to have calculated fields?? The

[firebird-support] performance on calculated fields - performance question

2015-04-29 Thread shg_siste...@yahoo.com.ar [firebird-support]
Hello! I have a customers table. I created some calculated fields in order to have the complete name of each customer in a single column. I attach the field definitions below. I don't know whether my calculated fields are complex or not to Firebird! I'm testing with aprox 40.000 rows