UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Performance Issue ?, Access 2007    
 
   
Sailor
post Feb 12 2019, 12:18 PM
Post#1



Posts: 88
Joined: 14-December 16



I have the following relationship (one to many) :

table1 ---------------------------------------------------------------- table2
_________________________________________________________________________
PK customer_id (long integer) -----------------------------------------> item_number (long integer)
---- customer_name (txt)----------------------------------------------- store_name (txt)
---- address (txt)-------------------------------------------------------- is_checked (Y/N)
---- city (txt)------------------------------------------------------------- save_date (short date)
---- phone_No (txt) ------------------------------------------------------ expire_date (short date)
---- gender (txt)---------------------------------------------------------- is_sold (Y/N)
---- birth_date (short date)---------------------------------------------- store_No (long integer)
---------------------------------------------------------------------------- batch_No

for any new record created in table1 there will be 34 related records in table2

my question is : with that sort , is there any performance issue ?

I wonder if we have 2000 records in table1 which will related with 2000 x 34 in table2
would that slow down the operations ?
Go to the top of the page
 
GroverParkGeorge
post Feb 12 2019, 12:20 PM
Post#2


UA Admin
Posts: 34,825
Joined: 20-June 02
From: Newcastle, WA


Probably not, but it depends a LOT on what operations you implement and how.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
dashiellx2000
post Feb 12 2019, 12:20 PM
Post#3


UtterAccess VIP
Posts: 9,826
Joined: 11-March 05
From: Maryland


The number of records you are mentioning is well within Access ability to manage very quickly. I routinly have db with hundreds of thousands records and if everything is normalized, indexed and relationships are set up properly you should not have issues due Access.

--------------------
William
“We're run by the Pentagon, we're run by Madison Avenue, we're run by television, and as long as we accept those things and don't revolt we'll have to go along with the stream to the eventual avalanche"
Go to the top of the page
 
Sailor
post Feb 12 2019, 12:33 PM
Post#4



Posts: 88
Joined: 14-December 16



The operations are :

Filtering table2 for a specific names , DoCmd.runSQL to Update some values , Add records

I have only one PK which is customer_id
my DB is splitted into FE,BE

How do I to make "everything is normalized, indexed and relationships are set up properly" .
This post has been edited by Sailor: Feb 12 2019, 12:38 PM
Go to the top of the page
 
GroverParkGeorge
post Feb 12 2019, 01:11 PM
Post#5


UA Admin
Posts: 34,825
Joined: 20-June 02
From: Newcastle, WA


Here's an excellent place to start.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Sailor
post Feb 12 2019, 01:34 PM
Post#6



Posts: 88
Joined: 14-December 16



Well ,, I would like to thank you guys hat_tip.gif
Go to the top of the page
 
John Vinson
post Feb 13 2019, 07:26 PM
Post#7


UtterAccess VIP
Posts: 4,279
Joined: 6-January 07
From: Parma, Idaho, US


What real life Entity is modeled by Table2? What is the Item_Number - is it in fact the same as the CustomerID? Does Table2 have a Primary Key (it can't be Item_Number if there are 34 records)? Why 34??

I'm very dubious that these tables are set up correctly! I agree that performance should be no problem (these tables are TINY), but I'm not sure about the logic.

--------------------
John W. Vinson
Wysard of Information
Go to the top of the page
 
Sailor
post Feb 14 2019, 01:36 AM
Post#8



Posts: 88
Joined: 14-December 16



QUOTE
What real life Entity is modeled by Table2? What is the Item_Number - is it in fact the same as the CustomerID? Does Table2 have a Primary Key (it can't be Item_Number if there are 34 records)? Why 34??

I'm very dubious that these tables are set up correctly! I agree that performance should be no problem (these tables are TINY), but I'm not sure about the logic.

John Vinson


Well , it's just a nicknames of my real tables and data
however , the fields types are the same

item_number is a distinct value that identifies the link between the tables ,
(any customer has a specific 34 items,with item_number we specify which items is belong to him),
there's a changes in a certain checkboxes that belongs to a specified customers, it should be belonged to a specific customer

why 34 items ? dontknow.gif


table2 have no PK

I have described the structures in the first post
This post has been edited by Sailor: Feb 14 2019, 01:52 AM
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    23rd April 2019 - 05:31 AM