Re: Which is the fastest way to access large databases?
Another thing that was glossed over is that if possible, you might want to avoid having 2000 records in a DB. While it will work fine, it can lead to long sync times (especially on DB creation). I'm not sure it's feasible in your case, but consider having more than one data-record per Palm record. This will of course create issues with sorting, etc, but if you're concerned about Hotsync time (like you implied), you might consider it. Hi everybody! I'll start to write a program that will access a database with 2000 records. My problem is that i don't know which is the fastest mecanism than Palm OS has to do this. My database will have these fields: Code,Product,Embal,Value Sometimes,I'll need to find a record using the Code, another time, using the Product name. Which function can I use to search into a database and return me the record index or the record unique id in less than a second, without creating indexes tables that will make my hotsync time increase from 2 to 5, 6 minutes? If i should make some changes into my db structure (like sort a column), please tell me the better way to improve performance -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
RE: Which is the fastest way to access large databases?
My database will have these fields: Code,Product,Embal,Value Sometimes,I'll need to find a record using the Code, another time, using the Product name. Which function can I use to search into a database and return me the record index or the record unique id in less than a second, without creating indexes tables that will make my hotsync time increase from 2 to 5, 6 minutes? Generally, I would do this. Sort your database by Code, and keep it that way. Then, create another database that points to the original DB, and looks like this: Product, record id in original DB Sort this DB by Product. When you need to search by code, search your main DB, when you need to search by Product, search the lookup DB. I'm sure someone else might have refinements of this strategy, but the basic concept has worked fine for me. Good luck! - Colin -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
Re: Which is the fastest way to access large databases?
Thanks Colin, I'll create a index DB that will have that thing that you told-me. Now, I'm with another quertion. O don't want to transfer the Index DB during a hotsync operation. Is there anyway to create this sorted DB directly on PALM, at runtime? Thanks a lot again! -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
Re: Which is the fastest way to access large databases?
On Sun, Jul 07, 2002 at 03:12:46PM -0300, Régis Daniel de Oliveira wrote: Thanks Colin, I'll create a index DB that will have that thing that you told-me. Now, I'm with another quertion. O don't want to transfer the Index DB during a hotsync operation. Is there anyway to create this sorted DB directly on PALM, at runtime? You can create a database directly on the Palm, using the Data Manager API. Btw, probably you don't even need a second DB for the index, but simply a record in your primary DB to store record indexes stored after the desired column order. Then you can load in memory the index record and use binary search to find the proper record index. Marco -- Marco Pantaleoni [EMAIL PROTECTED] Padova, Italy [EMAIL PROTECTED] elastiC language developer http://www.elasticworld.org -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/
Re: Which is the fastest way to access large databases?
On Sun, Jul 07, 2002 at 08:19:14PM +0200, Marco Pantaleoni wrote: a record in your primary DB to store record indexes stored after ^^ sorted Marco -- Marco Pantaleoni [EMAIL PROTECTED] Padova, Italy [EMAIL PROTECTED] elastiC language developer http://www.elasticworld.org -- For information on using the Palm Developer Forums, or to unsubscribe, please see http://www.palmos.com/dev/support/forums/