dbTalk Databases Forums  

Performance PSQL 10

comp.databases.btrieve comp.databases.btrieve


Discuss Performance PSQL 10 in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #51  
Old   
Brad Kunkel
 
Posts: n/a

Default Re: Performance PSQL 10 - 02-26-2008 , 11:32 AM






"Guy Dawson" <gnues (AT) crossflight (DOT) co.uk> wrote

Quote:
Our 8.6 and 9.5 servers do suffer a slow down if they're asked to do
big table scans. That is of course par for the course. Perhaps the
application was asking a lot of the database.

I agree that it is probably my application but I haven't been able to
pinpoint what is happening yet. The app that has the slowdown issue uses
transactional access and I can't think of anywhere that entire tables are
scanned. There is some sort of processing bottleneck, though, and I think
it is local to the user's station since people do not tell me that the whole
network is slowing down.

Thanks,
Brad Kunkel
Integrated Business, Inc.




Reply With Quote
  #52  
Old   
Brad Kunkel
 
Posts: n/a

Default Re: Performance PSQL 10 - 02-26-2008 , 11:32 AM






"Guy Dawson" <gnues (AT) crossflight (DOT) co.uk> wrote

Quote:
Our 8.6 and 9.5 servers do suffer a slow down if they're asked to do
big table scans. That is of course par for the course. Perhaps the
application was asking a lot of the database.

I agree that it is probably my application but I haven't been able to
pinpoint what is happening yet. The app that has the slowdown issue uses
transactional access and I can't think of anywhere that entire tables are
scanned. There is some sort of processing bottleneck, though, and I think
it is local to the user's station since people do not tell me that the whole
network is slowing down.

Thanks,
Brad Kunkel
Integrated Business, Inc.




Reply With Quote
Reply




Thread Tools
Display Modes

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.