At 12:01 PM 3/20/2002 +0800, Kenneth wrote:

> my code code creates a prepared
>statement
>everytime i perform the insertion. (This limitation is unfortunately, due to
>the fact the
>Type4 FB JDBC driver doesn't support reusing a statement after commits)

Are you also doing a commit after each insert? That's making things
slower than they need to be ... at least in most cases.

>Just wondering if this has something to do with some internal memory
>management?
>But then again, it's just 2000 prepared statements. It can't possibly take
>25 seconds to free them all right?

Have you traced the memory usage of the server?



Regards,

Ann
www.ibphoenix.com
We have answers.