Thanks Karen (and others) - your I/O issue may explain some "bugs" that I
have encountered as well. I think I'll adopt a similar policy and switch to
inserting only constant values and not expressions.
----- Original Message -----
From: "tellef" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 9:43 AM
Subject: re: INSERT speed
> Bill:
>
> >Does anyone know if there is an appreciable speed difference
> >in INSERTing straight values versus using expressions?
>
> I'm not sure if there is a speed difference, but in versions
> at least up to 4.5 (not sure if it is more stable now because
> I don't code this way anymore) I would occasionally get a
> strange 'I/O' error when trying to insert using VALUES with
> an expression. This would cause the insert to fail, sometimes
> the program would continue, sometimes it would crash. So I took
> to creating my expressions first, then inserting the dotted
> variable. Totally fixed the I/O problem at the time.
>
>
> Karen
>
>
>
