On Wed, Sep 15, 2010 at 6:18 PM, Arjen Nienhuis <a.g.nienhuis@gmail.com> wrote:
> Hi,
> Inserting many of rows is almost always IO bound. Converting ints and floats
> to text is CPU bound and really fast anyway. To speed things up first look
> at things like indexes, how often you need to COMMIT or using COPY. Only
> then look at prepared statements and binary transfer modes. Else it's simply
> not worth the headache.
That's an awfully broad statement, and untrue...many applications are
cpu bound. It's easier to scale storage than cpu after a point. Also,
solid state storage is going to become increasingly common moving
forwards.
Not all type receiving parsing is trivial as you claim; timestamps and
bytea for example are significantly cheaper to send in binary wire
format. Anyways, libpqtypes gives you all the advantages without all
the fuss. If you are really looking to shave cycles we allow you to
prepare the format string as well as prepare the statement before
sending it. We wrote this interface for a reason: I'd say on average
it cuts down query time around 20% on average in addition to the other
advantages it provides.
merlin