473,322 Members | 1,523 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Normalisation Question perhaps?

Hi all,
I have been asked to look at an existing Access 2002 DB tasked with
adding some more features and improving the speed at which it runs. It is a
split fe/be application with around 30,000 records. The main form has quite
a lot of fields and I am trying to reduce them. Every morning, the users run
a SQL from the main works management system, save the text file and import
the data. One of the fields from the SQL they run (ipartid which is 20
characters) is split (from the original SQL) and imported into 5 separate
fields. My question is, would it be more efficient to import it as one field
and then split it down in the form i.e.
mid([import].[ipartid],1,5) or would it be quicker to leave it as 5 separate
fields?

I hope I have explained this OK

Thanks in advance,

Mark
Nov 13 '05 #1
3 1228
I'm not sure of the reason that the id is 5 part, but I suspect they
indeed refer to 5 separate attributes of the id. In which case they may
need to be split in all databases.

e.g.if the partid represents company, bin, category etc. then they will
probably be needed separtely in other or future queries.

Mark Reed <ma*********@ntlworld.com> posted in
news:4F***************@newsfe3-gui.ntli.net
Hi all,
I have been asked to look at an existing Access 2002 DB tasked
with adding some more features and improving the speed at which it
runs. It is a split fe/be application with around 30,000 records. The
main form has quite a lot of fields and I am trying to reduce them.
Every morning, the users run a SQL from the main works management
system, save the text file and import the data. One of the fields
from the SQL they run (ipartid which is 20 characters) is split (from
the original SQL) and imported into 5 separate fields. My question
is, would it be more efficient to import it as one field and then
split it down in the form i.e. mid([import].[ipartid],1,5) or would
it be quicker to leave it as 5 separate fields?

I hope I have explained this OK

Thanks in advance,

Mark


--
Phil
Nov 13 '05 #2
rkc

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:4F***************@newsfe3-gui.ntli.net...
Hi all,
I have been asked to look at an existing Access 2002 DB tasked with
adding some more features and improving the speed at which it runs. It is a split fe/be application with around 30,000 records. The main form has quite a lot of fields and I am trying to reduce them. Every morning, the users run a SQL from the main works management system, save the text file and import
the data. One of the fields from the SQL they run (ipartid which is 20
characters) is split (from the original SQL) and imported into 5 separate
fields. My question is, would it be more efficient to import it as one field and then split it down in the form i.e.
mid([import].[ipartid],1,5) or would it be quicker to leave it as 5 separate fields?


It would be silly do undo something that was done correctly. A multi-valued
field means your resulting table isn't even in first normal form. It means
you
have to do calculations every time you want the multiple pieces of
information
as seperate pieces of information.
Nov 13 '05 #3
Mark,
As a rule, it's generally easier to work in code with values split into
columns. If you think about the parts of a persons name: Prefix, First
Name, Middle Name, & Suffix, then consider the task of pulling out the
middle name using string manipulation, you don't have to work with it for
long before it becomes clear that it's a lot easier if the parts of the name
are in seperate columns. I'd split it on when I imported it.

"Mark Reed" <ma*********@ntlworld.com> wrote in message
news:4F***************@newsfe3-gui.ntli.net...
Hi all,
I have been asked to look at an existing Access 2002 DB tasked with
adding some more features and improving the speed at which it runs. It is a split fe/be application with around 30,000 records. The main form has quite a lot of fields and I am trying to reduce them. Every morning, the users run a SQL from the main works management system, save the text file and import
the data. One of the fields from the SQL they run (ipartid which is 20
characters) is split (from the original SQL) and imported into 5 separate
fields. My question is, would it be more efficient to import it as one field and then split it down in the form i.e.
mid([import].[ipartid],1,5) or would it be quicker to leave it as 5 separate fields?

I hope I have explained this OK

Thanks in advance,

Mark

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Michael Lauzon | last post by:
Database Normalisation Advisor Designated Contact: thox, xpl2 Status: Open Open Date: 2004-10-26 11:53 For Project: Lands of Myths & Legends (http://sourceforge.net/projects/lamyle/) Long...
1
by: Michael Lauzon | last post by:
Database Normalisation Advisor Designated Contact: thox, xpl2 Status: Open Open Date: 2004-10-26 11:53 For Project: Lands of Myths & Legends (http://sourceforge.net/projects/lamyle/) Long...
0
by: Michael Lauzon | last post by:
Database Normalisation Advisor Designated Contact: thox, xpl2 Status: Open Open Date: 2004-10-26 11:53 For Project: Lands of Myths & Legends (http://sourceforge.net/projects/lamyle/) Long...
2
by: David Allison | last post by:
Should Lookup fields be replaced by table normalisation? Then the Tables brought together in a Query for a Form to be based on? -- Dave Allison ~ Scotland
2
by: James W. | last post by:
Hi everyone, I would like to ask you lot if you know of a great place on the internet for a fool proof idiots guide to Normalisation 1st, 2nd, 3rd. I looked at webopedia but that is just as...
11
by: Michael Thomas | last post by:
Hi everyone Not sure if this is the right newsgroup to be posting to for this question, but I am using Access 2002 to develop a database solution for the company that I work for. It's basically...
3
by: Macbane | last post by:
Hello All, This has been bugging me for too long. I have a database that records medical interventions. I am familiar with the theory behind normalisation but am unsure what to do with the...
1
by: shauna | last post by:
hi, i am an As level student studying Applied ICT, im having problems with normalisation. our problem is to computerise a made up business.mine for example is a beauty salon. below are my...
2
by: hiyamwah | last post by:
Hi i am a little unsure of how you do this problem: A company wishes to allocate staff to a new project that as been proposed by the company. As a result, a new relation was created for this...
2
mikek12004
by: mikek12004 | last post by:
I have a table for categories (id->the primary key, and name) and I want to add another column parent (one category might be inside another) with the id's range of values so in fact parent will be a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.