Subject | Re: INSERT Performance |
---|---|
Author | robert_difalco |
Post date | 2005-06-18T16:49:04Z |
Thanks for the info.
So, I've noticed that BLOB inserts are slower than VARCHAR inserts for
data of the same size. I've sped things up a bit by replacing some of
the BLOBs with VARCHAR OCTET fields. Does that make sense or should
they be equivalent? I'm guessing if I'm IO bound that this is because
BLOBs are written to a different location (well that and that they
require a new socket/blob handle to be streamed to when using the JDBC
driver).
Also, could you educate me as to why Classic is a better choice here
than Super Server? I'll have a pool of about 14 connections. 20 max.
Should I be concerned about the number of processes?
TIA,
R.
So, I've noticed that BLOB inserts are slower than VARCHAR inserts for
data of the same size. I've sped things up a bit by replacing some of
the BLOBs with VARCHAR OCTET fields. Does that make sense or should
they be equivalent? I'm guessing if I'm IO bound that this is because
BLOBs are written to a different location (well that and that they
require a new socket/blob handle to be streamed to when using the JDBC
driver).
Also, could you educate me as to why Classic is a better choice here
than Super Server? I'll have a pool of about 14 connections. 20 max.
Should I be concerned about the number of processes?
TIA,
R.