Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Order of table fields
Mon, Jan 9 2017 1:22 PMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Hi All,

I think it should not - but just need to be sure, because i am going to
alter lot of tables and add a field with a index  Smile

Does order of table fields have effect on performance, like if adding a
important table field on last position? Hope it's understandable what's
i am asking for? Does primary key fields always need to be placed on top
(dbsys alter)?

Thanks in advance,

Hüseyin A.

Tue, Jan 10 2017 2:24 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Hüseyin


There shouldn't be any difference from what I remember. My habit though was to always have the primary key field(s) as the first, and in the correct order and any memo fields at the end of the table. Both hangovers from Paradox/BDE where it seemed to make a difference in speed & stability (especially the positioning of the memo fields).

Roy Lambert
Tue, Jan 10 2017 8:47 AMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Roy,

Thanks for input, i was lucky to start with DBISAM so I have never used
paradox/bde Smile

Regards,

Hüseyin


Den 10-01-2017 kl. 08:24 skrev Roy Lambert:
> Hüseyin
>
>
> There shouldn't be any difference from what I remember. My habit though was to always have the primary key field(s) as the first, and in the correct order and any memo fields at the end of the table. Both hangovers from Paradox/BDE where it seemed to make a difference in speed & stability (especially the positioning of the memo fields).
>
> Roy Lambert
>
Tue, Jan 10 2017 1:53 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Huseyin,

<< Does order of table fields have effect on performance, like if adding a important table field on last position? Hope it's understandable what's i am asking for? Does primary key fields always need to be placed on top (dbsys alter)? >>

No, not physically or in terms of performance.  But, *logically* it is best to place primary key fields at the top of the table structure.

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Jan 10 2017 4:11 PMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Tim,

Thanks for the confirmation Smile

Regards,

Hüseyin


Den 10-01-2017 kl. 19:53 skrev Tim Young [Elevate Software]:
> Huseyin,
>
> << Does order of table fields have effect on performance, like if adding a important table field on last position? Hope it's understandable what's i am asking for? Does primary key fields always need to be placed on top (dbsys alter)? >>
>
> No, not physically or in terms of performance.  But, *logically* it is best to place primary key fields at the top of the table structure.
>
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
Image