New features for smart work with text BLOBs in Firebird and InterBase for your programs and components
Do you know that OLE DB .Net provider and a number of other dedicated .Net components do not use stream reading to access Firebird and InterBase BLOB fields, but immediately load the entire BLOB object to memory?
What will happen to server memory if such component contains a table with more than a thousand of large images or, which is even worse, a thousand of video files? Of course, they all will be loaded to memory!
But not with IBProvider
IBProvider has long been using streams and loading data on an as-needed basis. Thus, when accessing an entry, you get not the entire BLOB object, but only the information you have requested.
As you know, we actively develop .Net Provider to access Firebird and InterBase and in today’s release of IBProvider we have implemented external interfaces to work with streams of characters.
Now all components that use IBProvider can work with BLOB objects as with streams of WideChar/MultiByte characters. For these purposes, 2 dedicated interfaces have been defined:
- IIBP_SequentialStream_WideChar
- IIBP_SequentialStream_MultiByteChar
You can find the description of these interfaces in the file “lib\ole_lib\oledb\ibprovider\oledb_ibprovider.h”.
Please pay attention that the SIZE_T data type is used instead of ULONG — this was made for transparent support of 32- and 64-bit applications.
The new interfaces fill the gap in the OLE DB standard, which has only one defined way of receiving data as a stream – via objects with the ISequentialStream interface oriented for binary data.
In the next releases, these way of accessing data will be used in LCPI .NET Data Provider for OLE DB in the implementations of advanced constructs and algorithms for reading/writing of text BLOBs.
If you work with the provider directly via its interfaces or you can influence the formation of DBBINDING::pObject, you may already take advantage of the new way of accessing data.
Each release – new algorithms
We believe that there is no need to describe in detail dozens of algorithms and functions redesigned and optimized each time a new version is released. Each IBProvider version involves:
- Multilevel testing
- Correction of detected and potential (!) errors
- Optimization of the work of algorithms
IBProvider today is no longer only OLE DB provider
We are constantly analyzing current and potential capabilities of IBProvider. At the moment, we have reached the level when, if necessary, we will overstep the framework of the OLE DB standard to provide our customers the best services for interaction with Firebird and InterBase databases.
.Net Provider is only the beginning, that’s why when you choose IBProvider as a component to access any (!) versions of InterBase and Firebird, you ensure your easy and smooth transfer:
- To the new versions of InterBase and Firebird servers
- Between InterBase and Firebird servers
- To new programming technologies and environments
You can change everything except one thing:
Firebird and InterBase providing the fullest support of the capabilities of these servers:
Choose IBProvider Professional
Or purchase the time-unlimited version
In addition to our driver, you are GUARANTEED to receive all subsequent versions within a year absolutely FREE!