Sean,
I have been doing it the way i described for a very long time. With Working from home, and the upload speeds, i am looking for ways to speed up the processes for the users. Being more efficient is my goal
Jim Wagner
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Sean Cooper via groups.io <smcjb=yahoo.com@groups.io>
Sent: Wednesday, July 15, 2020 11:42 AM
To: MSAccessProfessionals@groups.io <msaccessprofessionals@groups.io>; MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Union Query vs. Append query
Sent: Wednesday, July 15, 2020 11:42 AM
To: MSAccessProfessionals@groups.io <msaccessprofessionals@groups.io>; MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Union Query vs. Append query
No not at all. Everyday a very large table is imported and then a make table query is run that retrieves the needed records and columns. Hence how I end up with the daily tables. I'd never thought of it before reading your question, but I could probably just append those records to a master record table. Would that be a better / faster way to handle it?
Sean
On Wednesday, July 15, 2020, 01:34:48 PM CDT, Jim Wagner <josephwagner2@outlook.com> wrote:
Sean,
is there a specific need or usage for the individual tables during the time frame between creation of the individual tables and the creating of the monthly tables? I am curious
Jim Wagner
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Sean Cooper via groups.io <smcjb=yahoo.com@groups.io>
Sent: Wednesday, July 15, 2020 10:51 AM
To: msaccessprofessionals@groups.io <msaccessprofessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Union Query vs. Append query
Sent: Wednesday, July 15, 2020 10:51 AM
To: msaccessprofessionals@groups.io <msaccessprofessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Union Query vs. Append query
Let me ask a related question.
Everyday I add about a 1000 records to my database. I currently import these into a new table and then through a union query combine them with my currrent records. At the end of the month I take all the daily tables and combine them into a monthly table and modify the union query to reflect that. So currently I have a union query that is combining 6 tables of monthly data and approximately 10 days of daily data to create a master data set. Would it be better if I just appended the new data everyday to a single table?
Sean
On Wednesday, July 15, 2020, 12:22:12 PM CDT, Paul Baldy <pbaldy@gmail.com> wrote:
I'm confused, as the two types of queries do different things. You'd need to use the type that accomplished your goal.
Do you get 295k new records a day, or is that the total number of records in the table? If the total, that's not really a large number, so you may not need to delete records.
Paul
On Wed, Jul 15, 2020 at 09:43 AM, Jim Wagner wrote:
Do you get 295k new records a day, or is that the total number of records in the table? If the total, that's not really a large number, so you may not need to delete records.
Paul
On Wed, Jul 15, 2020 at 09:43 AM, Jim Wagner wrote:
Hello all,
I download every day records from hyperion and bring them into the database after exporting them to excel and then importing them into the database. because the record count is 295K i delete the records in the database from a certain date and then append the newly downloaded records thus keeping my record count low.
But I was thinking today. what would be faster to do a union query or an append query?
Thanks for the thoughts
Jim Wagner
Tidak ada komentar:
Posting Komentar