Den 2011-12-30 21:43 skrev Leyne, Sean såhär: > Dmitry, > >> Trunk is the ongoing development branch (formerly known as HEAD in CVS), >> i.e. transaction IDs are already unsigned long in FB 3.0. > Although this would mean a further ODS change as well as an increase in > overhead associated with all rows, perhaps the ODS size should be increased > from 4 bytes to 5 bytes to remove any possible likelihood of overflowing the > max value (=256 transactions per sec, continuously for over 136 years!) Who knows what will happen within only 5-10 years? Perhaps in five years, it will be common with systems running a few thousand transactions per second? In that case 40 bits will only suffice for about 11 years (3000 trans/sec).
If such a "big" change is to be made I suggest to make it at least 48 bits, and why not 64 bits while we're at it? At least I was under the impression that the snag is not the size and space it takes on disk, but rather that the trans id type is used in so many places that the change is high risk. So, if it's to be changed at all, make sure the change is large enough for a long time. Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
