AQUANANU
Posts: 107
|
| Posted: 01/29/2009, 12:22 PM |
|
i have a table having a record containing 15 fields which store the id of the members from the table members.
for eg recordtable
recid - auto
shipper - numeric
buyer- numeric
Consignee- numeric
trucker - numeric
Packer - Numeric
insuranceco - numeric
all the above numeric fields have code from the members table
recid - auto
name - text.
address - memo
please advise will it be helpful in reducing the load on the server if the MS Access database had predefined relationships between each field from recordtable and members for each field.
Or it would be good if i move the database to sql. the database is 100 mb currently
_________________
Navneet Kakkar
CEO
Positive Thinker's Inc. |
 |
 |
datadoit
|
| Posted: 01/29/2009, 1:36 PM |
|
SQL
|
|
|
|
Oper
Posts: 1195
|
| Posted: 01/29/2009, 2:52 PM |
|
Like Data Doit said you should go to SQL or MYSQL,
for many reason (but not speed)
but but.
Access is faster than MySQL,Oracle , Postgress, etc faster than any SQL Database
if and Just if the number of user accesing the Data is low (10-15 average)
we have aplication that we migrate from access to MySQL and really if low Number of user accesing the Data, MSAccess will eat any SQL
you should goto any SQL (like DataDoit suggested)
witjotu thinking twice
The Basic Problem with Access and why sometime is slow
is casue Access dont have Record Locking Access Lock Table
during Insert. but for low user you wont notice the delay.
Also Query/Views in Access are faster than any other SQL
dont get me wrong we still use Access for many small Project
really easy to Port/Copy/Move and for low user is great.
but for any project that will go over 10-15 we use MySQL.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
AQUANANU
Posts: 107
|
| Posted: 01/30/2009, 5:56 AM |
|
thanks oper and datadoit for your suggestions
can you please advise if it would be helpful if the access database has predefine relationships rather than the join statements in sql
i dont think it would be of any help as i still need to have the name field from members in the record set for each member type stored in the record for displaying in the grid
_________________
Navneet Kakkar
CEO
Positive Thinker's Inc. |
|
|
|
Oper
Posts: 1195
|
| Posted: 01/30/2009, 5:49 PM |
|
predefine relationships
will help keep Integrity of you data only
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
