Configuration Sql.ini

forum.sqlbase (1998-2010)
gupta

Configuration Sql.ini

Post by gupta » 27 Apr 2010, 22:32

 Posted by:  gupta 

Hi to everybody,

I have an important problem, it is installed SQLBASE 11.02 SP 3

eighty contemporary connections that often go exist

in timeout or they jam one with the other, according to you sql.ini is
shaped

correctly??

thanks max

FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Configuration Sql.ini

Post by FRBhote » 28 Apr 2010, 08:23

 Posted by:  F R Bhote 

The sql.ini looks fine.

I have the same problem with 11.02 - there are ridiculous timeouts and
deadlocks. This does not happen in similar locations which use 8.5. Also the
server regularly shuts down without any fail.sql.

Can I see you audit file please?

gupta

Configuration Sql.ini

Post by gupta » 28 Apr 2010, 09:04

 Posted by:  gupta 

Thanks for the help,

I attach the file of audit where the various conflicts are seen

with SQLBASE 11.5 can resolve at least partly my problems???

max

FRBhote
India
Posts: 1230
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

Configuration Sql.ini

Post by FRBhote » 28 Apr 2010, 12:57

 Posted by:  F R Bhote 

Your timeouts look quite logical. There is a Select MAX (which would use the
whole table) while there is an insert. And maybe the Select is taking a long
time.

If you change the @MID( PN151_PRENOTAZIONE, 0,5 ) = :2 to
PN151_PRENOTAZIONE LIKE instead, you should get much better results if there
is an index on PN151_DITTA, PN151_PRENOTAZIONE.

gupta

Configuration Sql.ini

Post by gupta » 29 Apr 2010, 21:41

 Posted by:  gupta 

I follow his/her indications and I thank her/it to have consulted my problem
list

thanks

Max

Return to “forum.sqlbase”

Who is online

Users browsing this forum: [Ccbot] and 0 guests