Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
Order of table fields |
Mon, Jan 9 2017 1:22 PM | Permanent Link |
Huseyin Aliz myBiss ApS | 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 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Huseyin Aliz myBiss ApS | Roy,
Thanks for input, i was lucky to start with DBISAM so I have never used paradox/bde 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Huseyin Aliz myBiss ApS | Tim,
Thanks for the confirmation 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 > |
This web page was last updated on Wednesday, March 27, 2024 at 05:29 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |