database structure & speed

[Ruslan Zasukhin]

On 12/2/04 2:29 AM, "Ralf Sander" <ralf at end-if.de> wrote:

Hi Ralf, 

> I want to keep my database customizable through the user, and wonder
> which is the best way to build it.
> Some fields are predefined but the user can add additional ones.
> 
> Using methods to create all fields and access fields through field
> names is slower than using objects.

You have test this ?

> But if I use a cursor for adding
> records or changing field values, I have to use field names (or index)
> instead of objects, too. Will I run into the same speed issues here?

You need write code which will work with any number of fields.
And you cannot use access by name because you cannot know names of future
fields.

You should use access by index.
This is quite fast.

> Or is it best to create objects for my fixed fields and access the
> userfields through methods?

In REALBasic ?

I wonder, you have test ?
You have real problem of speed ?
Or you just ASSUME ?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------