> There is a simple change which makes it much faster, tested with Linux > 2.5 embedded restore:
Well done ;) ... > My change creates this BLR: > blr_loop > blr_receive > blr_store > ... > > Calls isc_start_and_send first time then N-1 isc_send. Very good example of very old feature almost not used for a long time. Do you have idea how it could be propagated at DSQL level ? I.e. we could introduce some special syntax to create input stream of messages (like SUSPEND but waiting for next input message). > I suppose this works in all GBAK versions. I see no reason for it to not work ;) > PS: There is other restore improvement capable of take down time from > around 8.5s to 0.5s over TCP, but it still requires some analisys. Very interesting. Let me guess... batching of records ? Regards, Vlad PS Another not used feature is ability of statement to work with more then just one message. We can have few resultsets produced by the one stored procedure, for example. If drivers developers will not kill us ;) ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel