Best lib for large tables?
Best lib for large tables?
- Subject: Best lib for large tables?
- From: Joakim Jardenberg <email@hidden>
- Date: Mon, 29 Apr 2002 09:06:32 +0200
I need to manage a large set of data, and easily do lookups and
modifications to the data.
What I have found is that an simple "in memory" flat database is what I
need and I have looked at to libs/mods that seems to be able to do it. I
would like som advice.
My data will concist of around 5000-1000 "rows" each of them with the
following "fields"
"5 char string (numeric - but must be treated as string)", "4 char
alphanumering string", "2 char alphanumeric string", "empty or 2-4 char
string", "empty or 3-5 char integer", "empty or 2-4 char string".
Something like
{"10001", "F1I2", "A2", "", 100, ""}
{"10022", "E1O6", "A2", "",, "BB"}
In some cases, when I work my way down my data I may encounter an entry
that is:
{"10001", "F1I2", "A3", "", 200, ""}
and in that case the new entry shall not be added, but instead the
existing row shall be updated to read
{"10001", "F1I2", "A3", "", 300, ""}
etc...
I have looked at tableLib (has) and TableSearchServices (Victor Yee) and
they both look excellent and able to fullfill my needs. But is one
faster then the other when it comes to this amount of data? I will be
doing tons of lookups in existing tables as I add to them from my lists.
Or is there another, even better alternative?
/Jocke
-- Joakim Jardenberg
email@hidden - mer kontakt :
http://www.infinit.se/.sig
"Those who say that it cannot be done
should get out of the way of those who are doing it!"
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.