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.

Inserting a large number of rows into an Ultralite DB on the iPhone

2 posts in Ultralite Last posting was on 2012-08-29 17:47:57.0Z
Ryan VanAlstine Posted on 2012-07-09 07:11:16.0Z
Sender: 1fc4.4ffa80e9.1804289383@sybase.com
From: Ryan VanAlstine
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Inserting a large number of rows into an Ultralite DB on the iPhone
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ffa8414.2025.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Jul 2012 00:11:16 -0700
X-Trace: forums-1-dub 1341817876 172.20.134.41 (9 Jul 2012 00:11:16 -0700)
X-Original-Trace: 9 Jul 2012 00:11:16 -0700, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12744
Article PK: 1048585

I'm trying to insert a large number of rows into my
Ultralite DB on the iPhone and it is crashing my app. I
have been able to do it in a simulated environment but when
I move over to the device it fails.

I am executing the command in a loop and there are over 65k
rows with 22 columns (mostly strings) and when it gets to
about row 58k (sometimes more, sometime less) the app
crashes.

I have tried increasing the cache size, reserve size, page
size, hash size, and changing the commit flush parameters
but it seems to hit a wall every time.

Is there some tips that can help me work with large
datasets?

Thanks,
Ryan


Priyesh Posted on 2012-08-29 17:47:57.0Z
Sender: 7f09.503e54ed.1804289383@sybase.com
From: Priyesh
Newsgroups: sybase.public.sqlanywhere.ultralite
Subject: Re: Inserting a large number of rows into an Ultralite DB on the iPhone
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <503e55cd.7f33.1681692777@sybase.com>
References: <4ffa8414.2025.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 29 Aug 2012 10:47:57 -0700
X-Trace: forums-1-dub 1346262477 172.20.134.41 (29 Aug 2012 10:47:57 -0700)
X-Original-Trace: 29 Aug 2012 10:47:57 -0700, 172.20.134.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere.ultralite:12752
Article PK: 1020125

Ryan,
Are you using an ARC enabled application? Are you sure this
is not a memory related issue from the application code?

Priyesh

> I'm trying to insert a large number of rows into my
> Ultralite DB on the iPhone and it is crashing my app. I
> have been able to do it in a simulated environment but
> when I move over to the device it fails.
>
> I am executing the command in a loop and there are over
> 65k rows with 22 columns (mostly strings) and when it gets
> to about row 58k (sometimes more, sometime less) the app
> crashes.
>
> I have tried increasing the cache size, reserve size, page
> size, hash size, and changing the commit flush parameters
> but it seems to hit a wall every time.
>
> Is there some tips that can help me work with large
> datasets?
>
> Thanks,
> Ryan