| Why/How are there u_fields in Contact1 table? | |
Posted: Mon Feb 09, 2009 12:59 am |
Points: 0 |
|
petrovlis |
GoldMine Journeyman |
|
|
Joined: 31 Jan 2009 |
Posts: 33 |
Location: Netherlands |
|
|
|
|
|
|
|
GMPE sql /Vista Home Premium.
Via Sql Server Man.Studio Express/Open table Contact 1, I see that there are in CONTACT1 TABLE (with me)
also
U_Company
U_Contact
U_Lastname
U_City
U_State
U_Country
U_Key1
U_Key2
U_Key3
U_Key4
U_Key5
Why is that, should it be deleted ?? I have backups with sql Serv Man Studio Express.
Let me know and thanks
William |
|
|
|
|
| | |
Posted: Mon Feb 09, 2009 1:21 am |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
No! Don't delete them.
Those are 'uppercase shadow fields'. They are there just in case your SQL server is not case-insensitive. These are the fields that are really behind the indexes you use when you search their non-U_ counterparts.
One tip: When building SQL queries inside GoldMine, use the U_fields instead of their non-indexed counterparts. Your SQL server will love you for it and reward you with much faster query performance. |
|
|
|
|
| | |
Posted: Mon Feb 09, 2009 2:08 am |
Points: 0 |
|
petrovlis |
GoldMine Journeyman |
|
|
Joined: 31 Jan 2009 |
Posts: 33 |
Location: Netherlands |
|
|
|
|
|
|
|
DougCastell wrote: |
No! Don't delete them.
Those are 'uppercase shadow fields'. They are there just in case your SQL server is not case-insensitive. These are the fields that are really behind the indexes you use when you search their non-U_ counterparts.
One tip: When building SQL queries inside GoldMine, use the U_fields instead of their non-indexed counterparts. Your SQL server will love you for it and reward you with much faster query performance. |
Thanks for the Tip/quick reply, Regards
William |
|
|
|
|
Posted: Mon Feb 09, 2009 5:50 am |
Points: 0 |
|
bgannett |
GoldMine Guru |
|
|
Joined: 07 Sep 2007 |
Posts: 1820 |
Location: Pacific NorthWest |
|
|
|
|
|
|
|
I agree with Doug's comments. Those U_ fields apply only to the Indexed fields in Contact1. Fortunately most (but not all) fields in that table are indexed. |
|
|
|
|
| | |
Posted: Tue Feb 17, 2009 7:03 am |
Points: 0 |
|
DJ |
GoldMine Guru |
|
|
Joined: 29 Jun 2006 |
Posts: 2055 |
Location: Fitchburg, MA, USA |
|
|
|
|
|
|
|
Actually the indexes have remained relatively constant. True, those fields beginning with a U are contained in the existing indexes, but now that we are on the SQL backend SQL wearies are relatively quick with or without the indexes. Yes, I know, they are faster with the indexes, however, where before we were limited to our searching through the indexes, we no longer see this limitation. |
|
_________________ DJ Hunt
Phone: (978)342-3333
Email: DJ@DJHunt.US
GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US |
|
|
|
| | |
Posted: Tue Feb 17, 2009 1:15 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
query speed may not be too different when you have 5000 contacts, but if you have 300,000 contacts, searching without an index can be excruciating and cause performance issues. Auto-update statistics can help to alleviate this, but should only be turned on for GoldMine 7 and 8. |
|
|
|
|
ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|