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.

ULTRALITE DATABASE LIMITS QUESTION !!

6 posts in General Discussion Last posting was on 2003-01-17 14:50:48.0Z
George Papadopoulos Posted on 2002-12-29 15:54:35.0Z
Reply-To: "George Papadopoulos" <george@silica.com.cy>
From: "George Papadopoulos" <george@silica.com.cy>
Subject: ULTRALITE DATABASE LIMITS QUESTION !!
Date: Sun, 29 Dec 2002 17:54:35 +0200
Lines: 97
Organization: Silica Technology Services Ltd
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_001E_01C2AF63.59835EC0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4920.2300
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300
Message-ID: <fQh61V1rCHA.198@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 194-154-154-64.dyn-pool.spidernet.net 194.154.154.64
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:354
Article PK: 2172

Dear Sirs,
 
This is a question regarding the limits of the UltraLite Database. On the SQLAnywhere v8 datasheet ( filename : 4316_SQL_Datasheet_v10.pdf ) on the last page under the Database Statistics section, there is a discrepancy regarding the "Rows per Table" limit. It has it twice and on the first instance it says "limited by database size"  and 3 lines below "Rows per Table" appears again and this time it says "65534" !!
 
Which one of the two is the correct one?
 
We currently have an ongoing handheld project using embedded VC++ and a competing database technology product and we are considering moving to ASA Ultralite and/or PowerBuilder9/PocketBuilder.
 
I would like an answer from a Sybase/iAnywhere Solutions person that I can subsequently present it to my boss.
 
Best Regards and Season's Wishes
_______________________
George Papadopoulos
Senior Software Specialist
Silica Technology Services Ltd


Greg Fenton Posted on 2003-01-03 17:50:57.0Z
Date: Fri, 03 Jan 2003 12:50:57 -0500
From: Greg Fenton <greg.fenton.NO.SPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: ULTRALITE DATABASE LIMITS QUESTION !!
References: <fQh61V1rCHA.198@forums.sybase.com>
In-Reply-To: <fQh61V1rCHA.198@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <Ee8rrL1sCHA.338@forums.sybase.com>
Newsgroups: ianywhere.public.general
Lines: 16
NNTP-Posting-Host: 172.31.140.220
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:349
Article PK: 2167


George Papadopoulos wrote:
>
> We currently have an ongoing handheld project using embedded VC++ and a
> competing database technology product and we are considering moving to
> ASA Ultralite and/or PowerBuilder9/PocketBuilder.
>

Realize that if the limitation of 65534 rows-per-table will
affect you, then you might consider using ASA on CE instead of
UltraLite.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


George_Papadopoulos Posted on 2003-01-17 08:09:50.0Z
From: George_Papadopoulos
Date: Fri, 17 Jan 2003 03:09:50 -0500
Newsgroups: ianywhere.public.general
Subject: Re: ULTRALITE DATABASE LIMITS QUESTION !!
Message-ID: <4474EAA547BE2A98002CD89A85256CB1.0067316085256CA3@webforums>
References: <fQh61V1rCHA.198@forums.sybase.com> <Ee8rrL1sCHA.338@forums.sybase.com>
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:291
Article PK: 2114

Hi again,
Thanks for the quick response.

Why did Sybase introduced this limitation in the Ultralight option since
this limit does not exist in the ASA for WinCE?

Are there any plans to remove this limit in the future?

Best Regards
______________________________
George Papadopoulos
Silica Technology Services Ltd


Robert Waywell Posted on 2003-01-17 13:31:33.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <fQh61V1rCHA.198@forums.sybase.com> <Ee8rrL1sCHA.338@forums.sybase.com> <4474EAA547BE2A98002CD89A85256CB1.0067316085256CA3@webforums>
Subject: Re: ULTRALITE DATABASE LIMITS QUESTION !!
Date: Fri, 17 Jan 2003 08:31:33 -0500
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <i2ofS9ivCHA.161@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:290
Article PK: 2108

UltraLite is a completely different architecture very specifically
focused on providing a small footprint for handheld devices. UltraLite is
not a 'port' of downsized version of ASA. In that context the row limit was
part of the original spec for UltraLite, not something that was introduced.
We are always willing to consider enhancement requests, along with the
supporting business case.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<George_Papadopoulos> wrote in message
news:4474EAA547BE2A98002CD89A85256CB1.0067316085256CA3@webforums...
> Hi again,
> Thanks for the quick response.
>
> Why did Sybase introduced this limitation in the Ultralight option since
> this limit does not exist in the ASA for WinCE?
>
> Are there any plans to remove this limit in the future?
>
> Best Regards
> ______________________________
> George Papadopoulos
> Silica Technology Services Ltd


Graham Hurst Posted on 2003-01-17 14:50:48.0Z
Message-ID: <3E281848.A92DC82E@ianywhere.com>
Date: Fri, 17 Jan 2003 09:50:48 -0500
From: Graham Hurst <spam_guard_hurst@ianywhere.com>
Organization: iAnywhere Solutions (a Sybase company)
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: ULTRALITE DATABASE LIMITS QUESTION !!
References: <fQh61V1rCHA.198@forums.sybase.com> <Ee8rrL1sCHA.338@forums.sybase.com> <4474EAA547BE2A98002CD89A85256CB1.0067316085256CA3@webforums> <i2ofS9ivCHA.161@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
Lines: 24
NNTP-Posting-Host: 172.31.143.29
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:289
Article PK: 2109


> > Why did Sybase introduced this limitation in the Ultralight option since
> > this limit does not exist in the ASA for WinCE?

FYI, the row limit is due to only using 2 bytes for row addressing. This was
chosen to save space on the small devices that UltraLite was designed for. It is
consistent with the Palm limitation of 64k records in a PDB.

Going to 3 bytes would increase the limit to 524286 rows, but it would also
increase the space needed for row addressing by 50%. The latter increase would
not be acceptable to many current UltraLite users, who have applications pressed
for space, so we need to keep providing an UltraLite with the current row limit.
We have not yet seen enough demand for a higher UL row limit to warrant
providing an additional version of UltraLite with a higher row limit. As Rob
pointed out, on CE you can use ASA if you want a higher row limit.

Cheers,

Graham


Eric Bencina Posted on 2002-12-30 13:41:14.0Z
From: "Eric Bencina" <nospam_ebencina@ianywhere.com>
References: <fQh61V1rCHA.198@forums.sybase.com>
Subject: Re: ULTRALITE DATABASE LIMITS QUESTION !!
Date: Mon, 30 Dec 2002 08:41:14 -0500
Lines: 148
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01C2AFDF.36B16B40"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
Message-ID: <ANMMauAsCHA.161@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.142.32
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:353
Article PK: 2173

Hi George,
 
I believe that this is an error in the datasheet as the correct value for "Rows per Table" is 65534.  You may reference the following section of the online documentation for an accurate description of the limitations.  I will also see to it that the datasheet is corrected.
 
http://manuals.sybase.com/onlinebooks/group-sas/awg0800e/dbulen8/@ebt-link;pt=32287?target=%25N%15_32681_START_RESTART_N%25;;__prev_hit__=32674;__next_hit__=32684;DwebQuery=limitations
 
 
Eric Bencina
iAnywhere Solutions
"George Papadopoulos" <george@silica.com.cy> wrote in message news:fQh61V1rCHA.198@forums.sybase.com...
Dear Sirs,
 
This is a question regarding the limits of the UltraLite Database. On the SQLAnywhere v8 datasheet ( filename : 4316_SQL_Datasheet_v10.pdf ) on the last page under the Database Statistics section, there is a discrepancy regarding the "Rows per Table" limit. It has it twice and on the first instance it says "limited by database size"  and 3 lines below "Rows per Table" appears again and this time it says "65534" !!
 
Which one of the two is the correct one?
 
We currently have an ongoing handheld project using embedded VC++ and a competing database technology product and we are considering moving to ASA Ultralite and/or PowerBuilder9/PocketBuilder.
 
I would like an answer from a Sybase/iAnywhere Solutions person that I can subsequently present it to my boss.
 
Best Regards and Season's Wishes
_______________________
George Papadopoulos
Senior Software Specialist
Silica Technology Services Ltd