Re: Insert performance

On 16 Aug 2003 at 11:40, Josh Berkus wrote:

> Shridhar,
>
> > Unfortunately he can not use copy due to some constraints.
>
> Why not use COPY to load the table, and then apply the constraints by query
> afterwords?  It might not be faster, but then again it might.

Lol.. The constraints I mentioned weren't database constraints.. It need to
interface with another database module.. The data import can not be text..
that's a project requirement..

I should have been clearer in first place..

Bye
 Shridhar

--
O'Toole's commentary on Murphy's Law:    Murphy was an optimist.