Re: [Firebird-devel] Build for WASM
On 2/24/22 03:45, Adriano dos Santos Fernandes wrote: On 23/02/2022 06:40, Jiří Činčura wrote: You mean, running in the browser? Yes. Or any other place where WASM is/will be supported. I had a (very) brief look at it once. Main difficulties should be: - Memory manager - no mmap - Shared libraries - File I/O - Lock manager All these points should have a workaround for a limited environment, but one must work on them - improving abstractions and much testing and fixes, I suppose. I believe it should be a long work. It would have a good usage: allow usage of Firebird directly in web pages, running in the client. That would be awesome for users wanting to try Firebird. That port promises to be much more problematic than Android one. Certainly, if someone voluteers for that job it will be good, but I doubt we should spend project resources on it. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] INT64 and index keys
On 2/15/22 18:20, Vlad Khorsun wrote: I'd vote to remove idx_numeric2 in favour of idx_decimal and look how to improve Decimal128::makeIndexKey() performance. For example, it stores every 3 decimal digits into 10 bits using relatively complex (computationally) algorithm with shifts and multiplications. Storing every digit in 4 bits will use 2 bits per 3 digits more but should save come CPU circles, I believe. Yes, it does help - but not too much. select dat from biTest order by dat; (I reference sample from #7133) becomes 1.1% faster with less dense encoding. Pay attention - engine does a lot of other job, i.e. speedup of this particular place is certainly much more. Certainly we can use that performance increase for new index type. But I doubt it's worth breaking existing DECFLOAT indices. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel