Re: [SQL] Seeking advice regarding a design problem

2002-08-02 Thread Stephan Szabo
On 2 Aug 2002, Wei Weng wrote: > On Fri, 2002-08-02 at 14:24, Stephan Szabo wrote: > > On 2 Aug 2002, Wei Weng wrote: > > > > > I am running postgresql as database backend, and I have some scripts > > > dealing with constant incoming data and then insert these data into the > > > database, in a q

Re: [SQL] Seeking advice regarding a design problem

2002-08-02 Thread Wei Weng
On Fri, 2002-08-02 at 14:24, Stephan Szabo wrote: > On 2 Aug 2002, Wei Weng wrote: > > > I am running postgresql as database backend, and I have some scripts > > dealing with constant incoming data and then insert these data into the > > database, in a quite complex way, involving a couple of pro

Re: [SQL] Seeking advice regarding a design problem

2002-08-02 Thread Stephan Szabo
On 2 Aug 2002, Wei Weng wrote: > I am running postgresql as database backend, and I have some scripts > dealing with constant incoming data and then insert these data into the > database, in a quite complex way, involving a couple of procedures. > > But the performance of the database is worse th

Re: [SQL] Seeking advice regarding a design problem

2002-08-02 Thread Wei Weng
Forgot to mention, the version of postgresql I am running is 7.1.3. On Fri, 2002-08-02 at 12:16, Wei Weng wrote: > I am running postgresql as database backend, and I have some scripts > dealing with constant incoming data and then insert these data into the > database, in a quite complex way, inv

[SQL] Seeking advice regarding a design problem

2002-08-02 Thread Wei Weng
I am running postgresql as database backend, and I have some scripts dealing with constant incoming data and then insert these data into the database, in a quite complex way, involving a couple of procedures. But the performance of the database is worse than I had thought. After about 100 times o