steveboydon
Registered User.
- Local time
- Today, 01:18
- Joined
- Jul 21, 2011
- Messages
- 17
Hi All,
What are your thoughts and experiences on sefl joined tables. I have used them and they seem to work very well.
Overall would you say that they are slower, faster or the same as normal tables.
As a concept i find them really useful and try to use them in my apps.
For those who are unsure of a self joined table (maybe they even have another name) they currently work as below (for me0
id (number)
parentid (number)
afield
anotherfield - I often use this as a category type field
You then add the table twice to the relationship grid and link id from one side to parentid from the other.
What you then have is a way to automatically have a tree style system with multiple levels.
There are a few limitations, but in certain instances they work just fine.
Steve
What are your thoughts and experiences on sefl joined tables. I have used them and they seem to work very well.
Overall would you say that they are slower, faster or the same as normal tables.
As a concept i find them really useful and try to use them in my apps.
For those who are unsure of a self joined table (maybe they even have another name) they currently work as below (for me0
id (number)
parentid (number)
afield
anotherfield - I often use this as a category type field
You then add the table twice to the relationship grid and link id from one side to parentid from the other.
What you then have is a way to automatically have a tree style system with multiple levels.
There are a few limitations, but in certain instances they work just fine.
Steve
