skip to main content
Reference : Designing JDBC applications for performance optimization : Returning data : Choosing the right data type
  

Try DataDirect Drivers Now
Choosing the right data type
Retrieving and sending certain data types can be expensive. When you design a schema, select the data type that can be processed most efficiently. For example, integer data is processed faster than floating-point data. Floating-point data is defined according to internal database-specific formats, usually in a compressed format. The data must be decompressed and converted into a different format so that it can be processed by the database wire protocol.