Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Doc clarification - Connections per database

2 posts in Ultralite Last posting was on 2011-10-12 19:23:17.0Z
Andre Freitas Posted on 2011-10-11 23:00:49.0Z
Sender: 2fd5.4e94c40e.1804289383@sybase.com
From: Andre Freitas
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Doc clarification - Connections per database
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e94caa1.3146.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Oct 2011 16:00:49 -0700
X-Trace: forums-1-dub 1318374049 10.22.241.41 (11 Oct 2011 16:00:49 -0700)
X-Original-Trace: 11 Oct 2011 16:00:49 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12623
Article PK: 1048390

I need help understanding if its possible to get more than
14 open connections simultaneously to an Ultralite database
in iPhone OS.

http://dcx.sybase.com/index.html#1200/en/uladmin/fo-intro-s-5236376.html

The link above states that we can have up to 14 connections
per database for single threaded applications. And that we
can have up to 32 concurrent open connections. What I don't
understand is, even if you open each connection in one
separate thread (as my application is doing - the connection
is opened and closed in threads other than the main one),
you still reaches the 14 simultaneous connection limit. Is
there any way to go higher than that? How does Ultralite
recognizes that my application is not single-threaded?

Thanks in advance.


Tim McClements [Sybase] Posted on 2011-10-12 19:23:17.0Z
From: "Tim McClements [Sybase]" <mcclemenXnospam@sybase.com>
Newsgroups: sybase.public.sqlanywhere.ultralite
References: <4e94caa1.3146.1681692777@sybase.com>
Subject: Re: Doc clarification - Connections per database
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6109
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e95e925@forums-1-dub>
Date: 12 Oct 2011 12:23:17 -0700
X-Trace: forums-1-dub 1318447397 10.22.241.152 (12 Oct 2011 12:23:17 -0700)
X-Original-Trace: 12 Oct 2011 12:23:17 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12625
Article PK: 1048388

Hi Andre,

Here are the different limits/factors involved:

1. A single UL database can support up to 14 concurrent connections. This
restriction results from a fundamental implementation (efficiency) choice,
and is generally not considered onerous since 14 is a lot of concurrent
connections for an UL application. :)

2. When running separate databases concurrently, there's an arbitrary limit
on how many of those there can be. It's 8 concurrent databases for devices
and 32 for desktops.

3. There's also an arbitrary limit on the total number of connections to all
databases, which might work out to less than 14 * number-of-databases, but
again isn't something you normally run into.

The above limitations have nothing to do with how many threads an
application uses. UL doesn't care (and doesn't know) about what threads you
use, except that you must ensure that only a single thread accesses a
connection (in C++) or SQLCA object (in ESQL) at a time.

Now, my question for you: why do you need more than 14 connections?

- Tim

<Andre Freitas> wrote in message news:4e94caa1.3146.1681692777@sybase.com...
>I need help understanding if its possible to get more than
> 14 open connections simultaneously to an Ultralite database
> in iPhone OS.
>
> http://dcx.sybase.com/index.html#1200/en/uladmin/fo-intro-s-5236376.html
>
> The link above states that we can have up to 14 connections
> per database for single threaded applications. And that we
> can have up to 32 concurrent open connections. What I don't
> understand is, even if you open each connection in one
> separate thread (as my application is doing - the connection
> is opened and closed in threads other than the main one),
> you still reaches the 14 simultaneous connection limit. Is
> there any way to go higher than that? How does Ultralite
> recognizes that my application is not single-threaded?
>
> Thanks in advance.