former_SQLA_member1694894
Explorer
Member since ‎2010 Mar 10

User Statistics

  • 37 Posts
  • 0 Solutions
  • 7 Kudos given
  • 15 Kudos received

User Activity

Snapshot isolation: SA12 vs PostgreSQL

2022 Aug 11
Hi all Sa12 (my version is 12.0.1) has 3 snapshot isolation types: - snapshot - statement-snapshot - readonly-statement-snapshot My questions are: 1. Which of these is comparable to PostgreSQL MVCC (by default it use read committed isolation leve...

SELECT and LOCK management

2017 Jul 28
Hi all. I'm using SA12.0.1 on Linux and I'm comparing it with PostgreSQL behaviour when locks occurs. I need SELECT statements DON'T waits (eventually) locked tuples involved by updates. In PostgreSQL, in a similar scenario, the select statement retu...

SELECT performance degradation ...

2016 Aug 01
Hi all. I'm using SA12.0.1 on Linux. A module of our application execute scheduled and parallel (java multithread) queries (only SELECT statements ...) We've experience of progressive performance degradation passing from 5 parallel executions (of th...

Variable url in web client function

2013 May 03
Hi all. I'm using SA12.0.1 and I'm trying to use Http web client access .... something like: ALTER PROCEDURE "DBA"."SendXMLContent"(xmlcode long varchar) url 'http://server/service' type 'HTTP:POST:text/xml' How can I use a variable url (... for ...

Full smtp_sender don't works ...

2012 Dec 28
Hi I always used the following structure on ASA9: ... CALL xp_startsmtp('My Name<myname@domain.com>','localhost' ); ... But on SA12 it don't works (error 104) ! .... only works the semplified version (without angle bracket ... CALL xp_startsmtp('...
View more