[prev in list] [next in list] [prev in thread] [next in thread] 

List:       nsbasic-palm
Subject:    [nsbasic-palm] Re: method to exceed 8000 records in a database
From:       "John Carter" <nsb () jecarter ! com>
Date:       2005-09-30 20:44:57
Message-ID: dhk849+kko8 () eGroups ! com
[Download RAW message or body]

--- In nsbasic-palm@yahoogroups.com, "Fernando Gibert" 
<fernandogibert@t...> wrote:
> I'm using Tungsten E   8 MB
> Total records ...    12000
> I mean it should be enough,
> 
> I bind the whole database to the grid, so i asked if there was a 
maximum
> rows number into the grid.
> 
> fernando

The maximum number of rows that can be displayed in a grid is 8192.  
When you try to load 8193, POSE crashes with the message:
"NSBasic just wrote to memory location xxxxxxx causing a bus error"

I just did some testing using a program that writes a specified 
number of records to a database.  The record format is an integer and 
a 90 character string.  

John

> ----- Original Message ----- 
> From: "John Carter" <nsb@j...>
> To: <nsbasic-palm@yahoogroups.com>
> Sent: Friday, September 30, 2005 5:41 PM
> Subject: [nsbasic-palm] Re: method to exceed 8000 records in a 
database
> 
> 
> > --- In nsbasic-palm@yahoogroups.com, "Fernando Gibert"
> > <fernandogibert@t...> wrote:
> > > Thanks both you & carmine!
> > >
> > > My very problem is that after hotsynching a larga database, my 
app
> > that loads a grid with several fields of the database crashes.
> > >
> > > With about 8000 records grid and app act well, but with 15000 it
> > crashes givings an error that makes pda to be reseted with the 
rear
> > button.
> > >
> > > I tried to download the database in 2 files and append them 
inside
> > the pda, so was my question about the grid "mixture" posed.
> > >
> > > is there a limited number of records on a grid ????
> > >
> > > thanks
> > >
> > >
> >
> > There is a limit to the amount of memory available in the PDA.  
Which
> > device are you using?
> >
> > John
> >
> > >   ----- Original Message ----- 
> > >   From: Michael Verive
> > >   To: nsbasic-palm@yahoogroups.com
> > >   Sent: Friday, September 30, 2005 12:26 AM
> > >   Subject: Re: [nsbasic-palm] method to exceed 8000 records in a
> > database
> > >
> > >
> > >   Theoretically the Palm OS can support 64K records (earlier
> > versions were limited to 32K).  However, databases with that many
> > records pose a real problem for HotSync, with transfer times
> > increasing exponentially for large numbers of records.
> > >
> > >   You can test this yourself fairly easily.  Create a simple
> > application that creates databases with 1000, 8000, 16000, 32000, 
or
> > 64000 records, and time how long HotSync takes to transfer the
> > records.  You'll be astounded.
> > >
> > >   So, rather than create databases with large numbers of 
records,
> > it's probably better to create databases with fewer records but 
more
> > fields, more data per field, etc.
> > >
> > >   As for binding databases to a Grid, I don't believe that it's
> > possible to bind more than one database to a Grid - and I can't 
see
> > where that would be helpful.  Which database's data should be
> > displayed?  And, adding data to a database-bound grid shouldn't 
work,
> > because it destroys the relationship between the grid and the
> > database (which is also why you shouldn't attempt to delete 
records
> > from a database that's bound to a grid).
> > >
> > >   You may need to use techniques similar to those in the
> > ListLookup, LargeListScroll or TableDemo projects, using lists
> > or "arrays" of screen fields to scroll through large databases and
> > display subsets of database records.
> > >
> > >   Mike Verive
> > >   mverive@y...
> > >
> > >
> > >   gibertfernando <fernandogibert@t...> wrote:
> > >     From reading technical notes, it seems possible to exceed 
8000
> > records
> > >     in a database to 24000 records.
> > >
> > >     how can this be done ?
> > >
> > >     on the other hand. . . .
> > >
> > >     when trying to bind to a grid a big database app crashes.
> > >
> > >     is there possible to bind 2 or more equal databases to the 
same
> > grid ?
> > >
> > >     i've tried to add records from the second database to a
> > previous binded
> > >     grid but it also fails.
> > >
> > >     thanks
> > >
> > >
> > >
> > >
> > >
> > >
> > >     Complete Searchable Archive:
> > >     http://marc.theaimsgroup.com/?l=nsbasic-palm&r=1&w=2
> > >
> > >     Shortcut URL to this page:
> > >     http://groups.yahoo.com/group/nsbasic-palm
> > >     Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >   Complete Searchable Archive:
> > >   http://marc.theaimsgroup.com/?l=nsbasic-palm&r=1&w=2
> > >
> > >   Shortcut URL to this page:
> > >   http://groups.yahoo.com/group/nsbasic-palm
> > >
> > >
> > >
> > > ----------------------------------------------------------------
----
> > ----------
> > >   YAHOO! GROUPS LINKS
> > >
> > >     a..  Visit your group "nsbasic-palm" on the web.
> > >
> > >     b..  To unsubscribe from this group, send an email to:
> > >      nsbasic-palm-unsubscribe@yahoogroups.com
> > >
> > >     c..  Your use of Yahoo! Groups is subject to the Yahoo! 
Terms
> > of Service.
> > >
> > >
> > > ----------------------------------------------------------------
----
> > ----------
> >
> >
> >
> >
> >
> > Complete Searchable Archive:
> >  http://marc.theaimsgroup.com/?l=nsbasic-palm&r=1&w=2
> >
> > Shortcut URL to this page:
> >  http://groups.yahoo.com/group/nsbasic-palm
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >





Complete Searchable Archive:
 http://marc.theaimsgroup.com/?l=nsbasic-palm&r=1&w=2

Shortcut URL to this page:
 http://groups.yahoo.com/group/nsbasic-palm  
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/nsbasic-palm/

<*> To unsubscribe from this group, send an email to:
    nsbasic-palm-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


[prev in list] [next in list] [prev in thread] [next in thread]