My database systems haven't have pages for 15 years, based instead on
distributed objects serialized to storage for persistence.
Netfrastructure/Falcon did all record operations in memory using
database pages only for backfill. OK, I guess, but it didn't work for
distributed databases. If you start with a distributed database rather
than a single node database, you come up with entirely different
architectures.
The problem, however, is how does an existing product change
architectures? Beats me.
On 6/9/2022 9:18 AM, Adriano dos Santos Fernandes wrote:
On 09/06/2022 09:58, Dmitry Yemanov wrote:
09.06.2022 15:16, Adriano dos Santos Fernandes wrote:
Yes, it should work. However, I'm not going to remove the limit until we
introduce a denser compression. Also, we have a number of places where
records is stored unpacked in memory (rpb's, RecordBuffer, HashJoin,
etc), so longer records could increase server memory usage. This should
be improved somehow.
Yes, but it's so bad when one needs to improve their schema and hit a limit.
And sometimes the arbitrary limit is hit by few margin, like switching a
field encoding or small necessary increase in length.
The same with record formats limited to 255. It's so awful, and it's
related stuff, as the format could also be variable encoded to not
always use 2 bytes.
The problem, however, is that format-aware processing was found to be
slower. The dumb scheme presented above (with no real compression)
provided almost the same record size as RLE compression for mixed
"real-world" fields and was even denser for records with longish UTF8
fields, but it was also ~20% slower.
If the storage takes less space, is this slow down estimation calculated
also taking into account the slower number of pages read (when page is
not cached)?
Surely when page is cached that becomes more problematic. I think Jim's
databases had record caches instead of only page caches, probably to
avoid this type of problem.
Adriano
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
--
Jim Starkey, AmorphousDB, LLC
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel