Hi guys,
I'm attempting to run a query that I made and it is running way too slow. Everything seems to work fine until I add in a table (dbo_INIH) and a field from that table (TAKBY). The reaction I get when I add those fields is weird. Within 2 minutes the first page of the query will show, which is normal for my queries. I suppose Access decided that it will be easier to show the first page and then load the rest of the records, so at this point I would attempt to click the button that takes me to the last record. However, when the first page loads, it kind of freezes and when I move the mouse around the screen, the cursor doesn't change and when I try and click a button, it won't click because it is frozen. Again, this only happens when I add that field into the query (and the field is essential).
Any suggestions on how to speed this up?
Thanks in advance,
Raza
2 3049
This is occurring because there is so much data. It will go to the last record if you let it finish. If you have already pulled in your data based on specific criteria so that it will not pull in everything, then the only other option is to make it "Group By". This may speed things up a little.
Otherwise, it may be the table you are adding in(dbo_INIH). Instead of bringing this in directly, create another query and pull in this table (dbo_INIH) and all the fields, now select "Make table query" and run it.
Now, instead of bringing in the original table(dbo_INIH) , bring in the table you created off of this. In some instances this speeds things up.
Let me know if this helps.
Thanks
This is occurring because there is so much data. It will go to the last record if you let it finish. If you have already pulled in your data based on specific criteria so that it will not pull in everything, then the only other option is to make it "Group By". This may speed things up a little.
Otherwise, it may be the table you are adding in(dbo_INIH). Instead of bringing this in directly, create another query and pull in this table (dbo_INIH) and all the fields, now select "Make table query" and run it.
Now, instead of bringing in the original table(dbo_INIH) , bring in the table you created off of this. In some instances this speeds things up.
Let me know if this helps.
Thanks
The Make table query worked beautifully, thank you very much.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Tim Fountain |
last post by:
We've recently enabled slow query logging on a server and it's proving
interesting seeing which queries are bogging things down. This one is
puzzling me a little:
SELECT articleid, type, authorid, authorname, text, posted FROM
comments WHERE status = 'normal' ORDER BY posted DESC LIMIT 5;
The purpose of this query is to list the five most recent
(non-deleted) comments. Here is the table structure:
|
by: Jason |
last post by:
The following stored procedure is taking too long (in my opinion). The
problem seems to be the SUM line. When commented out the query takes a
second or two. When included the response time climbs to minute and a
half.
Is my code that inefficient or is SUM and ABS calls just that slow?
Any suggestions to spead this up?
Thanks,
- Jason
|
by: krystoffff |
last post by:
Hi
I would like to paginate the results of a query on several pages. So I
use a query with a limit X offset Y to display X results on a page,
ok.
But for the first page, I need to run the same query with a count(*)
to know how many pages I will get (number total of rows/ X).
The problem is my query is very slow (maybe 5s) because there is much
|
by: John |
last post by:
Hi
When I open a new outlook email from vb.net, sometimes outlook is very slow
to appear or occasionally outlook freezes completely. I am targeting mixed
office2000/xp environments so I am using the office2000 interop dlls
generated by vs.net by adding office 2000 com reference.
Any one else noticed this problem when targeting office2000/xp mixed
environments? Is there a better, more robust way to do this? Am I better off
using late...
|
by: Baiju |
last post by:
Hello
We have a web application which has a page to select value from three drop
down lists.
The first list box is populated when the page is loaded. The second one is
loaded based on the selection of the first one after submitting the pageand
so on.. The issue if I select a value in the first list box and try to
change it in a second the browser freezes. Any help in this ?
Thank you
| |
by: Howard, Steven |
last post by:
I have created a web app that stores and displays all the messages from
my database maintenance jobs that run each night. The web app uses Java
servlets and has PostgreSQL 7.0 as the back end.
When the user requests the first page, he gets a list of all the servers
with maintenance records in the database, and a drop down list of all
the dates of maintenance records. If the user chooses a date first, then
the app uses a prepared...
|
by: leegold |
last post by:
I use "core" styles from w3. But at the time of this email time W3 is down
ie. i cannot connect via browser to w3.org and any web page the uses the
core styles will freeze/hang.
Is there a way when w3 is site's slow or down to stop trying to connect and
just show the page? Or use an alternate css? This has never happened before
but when it did as now it freezes everything.
<link rel="stylesheet"...
|
by: Richard Hollenbeck |
last post by:
I hope this isn't too confusing.
The following query runs pretty fast by itself, but when I want to use it in
a report (pasted below the query), it takes at least fifteen seconds to run!
Then I want to analyze the query in Excel and I have to do some manual
tweaking. I'd like to run this same query as a summary for the whole class
without having to manually do it in Excel, rather in an Access report, but
that gets even more complicated....
|
by: existential.philosophy |
last post by:
This is a new problem for me: I have some queries that open very
slowly in design view.
My benchmark query takes about 20 minutes to open in design view. That
same query takes about 20 minutes to open in datasheet view. As an
experiment, I deleted all rows in all tables; after that, the query
took only seconds to open in both design view and datasheet view. From
these facts, I conclude that Access is evaluating the query when I go
to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |