Rabu, 15 Juli 2020

Re: [MSAccessProfessionals] Union Query vs. Append query

Paul,

Because I cannot export 295K and growing records to excel, I need to split the data in a way to get the data together.
after running the query in hyperion that has a filter date of >=1/1/2020 i export that data into the database.
then a delete query removes the records of >=1/1/2020 from the base table 295K.
then an append query adds the records from the current day download. which is >=1/1/2020.
so to answer your question, yes 295K is the total number of records. But it gets larger each day because it is a history table.
The other part of the issue is that working from home has reduced my speed of upload compared to the office. So splitting the recordset makes it easier to manage.
My purpose in asking the question was to find out if i really need an append query that processes the insert or is a union query more efficient?

Thank You
Jim

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Paul Baldy <Pbaldy@gmail.com>
Sent: Wednesday, July 15, 2020 10:22 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Union Query vs. Append query
 
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:
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