Reply
Postgre Database: Problem when insert new record
Old 07-15-2006, 12:08 AM Postgre Database: Problem when insert new record
Junior Talker

Posts: 1
Hi everyone!
I have a problem with my Web Application using Postgre Datbase, Strut and JSP:
- At the first time, when I insert new record with primary key is 01 into table A. The process is very slow, so I cancel this process.
- After that, I try to insert new record with primary key is 01 into table A, too. But the process also is very slow, too.
To resolve this problem, I must restart the service of Postgre in Server.
This problem occur sometime. It make me feel my Web Application is not stable.
So, I would like to ask you what the problem is. And how to resolve this problem?
I hope to receive the answer as soon as possible.
Thank you very much!
(If you need more detail information of the problem, ask me, please)
abigman is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 07-17-2006, 06:31 AM Re: Postgre Database: Problem when insert new record
ibbo's Avatar
Super Spam Talker

Posts: 880
Location: Leeds UK
Can you show us the table layout and the insert statement your using please.

Ibbo
__________________
www.nationalclubgolfer.com www.sportspub.co.uk www.bespokecc.co.uk www.centralmarquees.co.uk
Linux user #349545 :
(GNU/Linux)iD8DBQBAzWjX+MZAIjBWXGURAmflAKCntuBbuKCWenpm XoA7LNydllVQOwCf
ibbo is offline
Reply With Quote
View Public Profile Visit ibbo's homepage!
 
Reply     « Reply to Postgre Database: Problem when insert new record
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.11056 seconds with 12 queries