Hello everyone,
I have a report that has several queries behind it. The database is a
split database with the data on our network.
Usually, this report takes about 3 minutes to run (there is a lot that
happens with this one).
However, as of last week, its taking 45 minutes!
I copied the database to my machine and the report completes in about 3
minutes.
So, before going to IT pointing to a network issue, is there anything
else I should try? Any testing I can do?
Thanks.
Brian
4  1392 
Additional information that I just came across.
I had compacted the backend recently.
I relinked the database to a un-compacted database and it is running
fine.
So, does compacting cause an issue? Is there a way to reverse this?
Thanks
Brian
BerkshireGuy wrote: Additional information that I just came across.
I had compacted the backend recently.
I relinked the database to a un-compacted database and it is running
fine.
So, does compacting cause an issue? Is there a way to reverse this?
Not normally but have you tried compacting the front end as well?
Also, if no joy, take a copy of the uncompacted back end and compact it,
does the problem occur there and then?
--
1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d
On 17 May 2005 05:08:25 -0700, "BerkshireGuy" <bd*****@yahoo.com> wrote: Hello everyone,
I have a report that has several queries behind it. The database is a
split database with the data on our network.
Usually, this report takes about 3 minutes to run (there is a lot that
happens with this one).
However, as of last week, its taking 45 minutes!
I copied the database to my machine and the report completes in about 3
minutes.
So, before going to IT pointing to a network issue, is there anything
else I should try? Any testing I can do?
Thanks.
Brian
When it's fast, are you the only one who has the back-end open?
When it's slow, do 2 or more people have it open?
What are the client and server operating systems on the network?
Hello everyone.
The problem is resolved.
It looks like a compact corrupted something within one of the tables.
I took a backup copy of the system, restored it, and reimported the
table I needed.
All seems fine now.
Thank you,
Brian
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Test Test |
last post by:
Hi, group!
Here is some interesting problem:
Our company has developed a large VB6 application that runs very smoothly on
most environments.
However, all of a sudden one of our customers...
|
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,...
|
by: Timo |
last post by:
I just got a new dual opteron system, with raid 01, 2gb ram, and fedora
core linux running 2.4.22-smp kernel. For some reason mysql is running
pathetically slow. Queries that should take 2ms...
|
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used...
|
by: google |
last post by:
I am creating a new database for use within our company, that I'd like
to make reasonably secure (short of a true server based solution). The
back-end of a non-server based database seems to be...
|
by: Daz |
last post by:
Hi everyone.
I was faced with the choice of whether my problem is indeed a PHP
problem or a MySQL. I have decided it's a PHP problem as I don't
experience the same problem when I execute the...
|
by: gnomee2 |
last post by:
Hello Everyone,
I have a strange problem that I cannot seem to solve. I have two server running Windows 2003 MSSQL on one IIS on the other.
Out of the blue I have slow queries that cause asp...
|
by: ngrTerry |
last post by:
I have been developing on my Laptop (1.9Ghz 512MbRam) in VB.NET2005
for two years now and all of a sudden my performance has reduced
dramatically.
I have defragged the hard drive, but no...
|
by: Marc Baker |
last post by:
Bear with me here folks, I don't know much MS SQL performance.
Wondering if someone can point me in the right direction. I have 1
particular database where queries are slow. To test this theory,...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have 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,...
|
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...
|
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...
| |
