> > No -- with a single connection only 1 SQL can be executed at a time -- > regardless of the number of threads to your process. > > With current Firebird architecture - yes. It can be changed.
Really, then why have we been living with that @#$@#$@# limitation for more than 10 years! > > I want to push data to another database as fast as possible, I want to have > > 5 > connections walk the list of tables and read the rows and push them to the > target DB. > > With current Firebird architecture you won't get better performance from 5 > connections. > Dmitry Kouzmenko some time ago made a video that busted this myth. I find that almost impossible to believe. The advent of high IOPs Flash/SSD and PCIe/SSD which are capable of 100K's of read IOs, would mean that disk would be able to provide as much more data than even 64 processes/thread could handle. Sean ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
