Reference | Help | Introduction | Slide Show | Class Hierarchy | InterClient
PREV | NEXT | FRAMES | NO FRAMES |  |

# A Few Performance Hints

I've started to collect a few performance hints. If you have any more please mail them to me, and maybe we'll publish this along with the rest of our documentation sometime in the future.

- Use VARCHAR for large text fields
  CHAR strings are fixed length and not compressed by the current interclient remote protocol.
- Use StringBuffers when concatenating large strings
- Use the interbase.interclient.Adaptor when stepping thru Date/Times.
- Use Statement.setFetchSize()
- Use stored procedures for lots of inserts
- Use prepared statements for repeated executions of SQL, possibly parameterized.

Reference | Help | Introduction | Slide Show | Class Hierarchy | InterClient
PREV | NEXT | FRAMES | NO FRAMES |  |

Send comments or suggestions to interclient@interbase.com