Different response times...

I have a VB 2005 program that uses an Access 2000 database that sits on a 
network drive. I'm using an oledb connection. From my PC, either through 
Visual Studio, or running the app itself, the program can query the database 
quickly (maybe a quarter second for a simple INSERT query). If I'm running 
the app from another pc on the network, the same INSERT query is taking about 
12 seconds. I have tested this same program on multiple PCs with the same 
result.  Also I installed Visual Studio on one of the 'slow' PCs and the 
response time went from 12 seconds down to 3 or 4 seconds, so as I assumed, 
it must be a software issue. But I still cannot pin down what particular 
piece of software is missing.
0
Utf
1/17/2008 6:32:00 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies
763 Views

Similar Articles

[PageSpeed] 6

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Don't use an OLEDB (ADO) connection.  You can connect direct to and .mdb
file using DAO.  I'm partial to DAO - various comparison tests done w/
DAO & ADO show that DAO is as fast as or faster than ADO.

A trick that sometimes increases connection speed w/ .mdb files is to
use a short path to the file (DAO).

You could try to find out what connection type the VS is using.... ;-).
-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup.  I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR5CfV4echKqOuFEgEQLjVQCeMxld4TsPV/PYHekfEtdPzSYQsFQAn2YO
ltguDsM0bxLPTjmSOUIYOfpb
=un3r
-----END PGP SIGNATURE-----


ctbny wrote:
> I have a VB 2005 program that uses an Access 2000 database that sits on a 
> network drive. I'm using an oledb connection. From my PC, either through 
> Visual Studio, or running the app itself, the program can query the database 
> quickly (maybe a quarter second for a simple INSERT query). If I'm running 
> the app from another pc on the network, the same INSERT query is taking about 
> 12 seconds. I have tested this same program on multiple PCs with the same 
> result.  Also I installed Visual Studio on one of the 'slow' PCs and the 
> response time went from 12 seconds down to 3 or 4 seconds, so as I assumed, 
> it must be a software issue. But I still cannot pin down what particular 
> piece of software is missing.

0
MGFoster
1/18/2008 12:45:17 PM
Reply:

Similar Artilces:

difference send as / receive as
Hi, I know that if you want under E2K "service account" access to mailboxes you must give yourself "send as"/ and "receive as" access ". But can anyone please tell me the whaht is the difference between the two permissions ? Regards Jenny Jenny wrote: > Hi, > > I know that if you want under E2K "service account" access to mailboxes you > must give yourself "send as"/ and "receive as" access ". But can anyone > please tell me the whaht is the difference between the two permissions ? > > Regards Je...

Updating two two tables based upon the response to questions in a subform
Me again. I'm trying to populate two tables based upon the results to questions on a subform. I have a form and one subform. The subform has a variable number of questions related to the form. Each question is limited to either "Pass", "Fail", or "N/A". If the user should select "Fail" on a question, I want to add a record to a table called "tblCARs" and a record to a table called "tbl CARLineItems". However, for every subsequent "Fail" response I want (need) to only add a record to the table "tblCARLi...

Differences in various auto-fit options (2007)
Does anyone know why these two autofit mechanisms give different results? 1. Right-click in table | AutoFit | AutoFit to Contents. 2. Select entire table | Double-click right border. Right-clicking in a table brings up a list of options. One of them is Auto-Fit. Selecting Auto-Fit, brings up three options: AutoFit to Contents (AFTC) AutoFit to Window (AFTW) Fixed Column Width (FCW) AFTW makes the table as wide as possible. I am not sure how it decides how wide to make each column. AFTC doesn't seem to work all the time. I have a table with 18 columns on a le...

Counting how many different names in a long list
I have a list of 332 names many of them are duplicated. I am looking for a formula or function that can count how many unique names there are in the list. Can anyone help? -- Quaisne ------------------------------------------------------------------------ Quaisne's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28052 View this thread: http://www.excelforum.com/showthread.php?threadid=501357 This'll count the number of distinct values in a range: =SUMPRODUCT((A1:A99<>"")/COUNTIF(A1:A99,A1:A99&"")) (adjust the range to matc...

Easier Time Entry
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi Everyone, <br><br>I'm a newbie to this forum. Please apologize if this question has been asked before. Though I did search before I post this question. <br><br>I did some look-around in the forum of Excel for PC and come across someone suggesting the following website for an easier way to do time entry in Excel, but I don't think this works with Excel 2004 for Mac since I tried and it doesn't work. <br><br><a href="http://www.cpearson.com/excel/datetimeentr...

Unable to update free/busy time
Hi there, This morning I installed the Exchange 2000 post-sp3 rollup on our small business server. Since then users have been getting messages from Outlook saying that it can't update free/busy time on the server. Prior to installing the rollup we did not get the errors. I had a look at the event log on the server and it is filling up with EventID: 1546 errors, the description is: Workflow event sink error [event: OnSyncSave, URL: <file://./backofficestorage/test.com.au/Public Folders/NON_IPM_SUBTREE/SCHEDULE+ FREE BUSY/EX:_xF8FF_o=DSPACE_xF8FF_ou=first administrative group/USER-_xF8...

Run-time error '5'
Hello, I'm getting a weird error on one of our computers. As soon as I open Excel and click anywhere on the sheet, I get an error: Run-time error '5' Invalid procedure or call argument This is just a blank document, with no macros or VBA code. Why am I getting it? I would appreciate your help. Thank you, -- Peter Afonin Hi try removing all add-ins -- Regards Frank Kabel Frankfurt, Germany Peter Afonin wrote: > Hello, > > I'm getting a weird error on one of our computers. As soon as I open > Excel and click anywhere on the sheet, I get an error: > ...

Calculating date difference
Hi I need to calculate the number of years of service for person(difference between Start_Date & End_Date). The result should b in terms of years, months and days (all in one single cell). Ca someone please help? Thanks ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com Have a look at Chip's site: http://www.cpearson.com/excel/datedif.htm Andy. "rll" <rll.xjm6a@excelforum-nospam.com> wrote in message news:rll.xjm6a@excelforum-nospam.com... > &...

Corporate or Workgroup, send from different accounts
I have been using Outlook 2000 (CW) in order to attach history to my contacts in ACT! This has been running well. The problem I've run into is I used to be able click on the "Send" button and choose a different email account to send from, I no longer have that option since I set up the workgroup settings. The email account that I can't send from is a Linux firewall account we use for internal emails...I can receive emails, but I can't reply or send new messages. They keep coming back as undeliverable. Any suggestions/feedback would be greatly appreciated. ...

Total Minutes Worked Within IVR Timing
Hi, I need to figure out how many total minutes employee worked during the IVR Timing. Each employee works different shift and it can run overnight into next morning where there may be IVR coverage before employee logs out. IVR Timing is same for Saturday/Sunday and same from Monday to Friday. IVR Timing Table; data type is Date/Time but only Time is available because date should be same as the schedule date DayIs IVRStart IVRStop Sunday 10:00:00 AM 6:00:00 PM Monday 9:00:00 AM 9:00:00 PM Tuesday 9:00:00 AM 9:00:00 PM Wednesday 9:00:00 AM 9:00:00 PM Thursday 9:00:00 AM ...

Writing XML from Dataset to Response Object as Binary File
I have looked fot his solution, but Im not sure what to search for. I have an asp.net based report. I need the user to be able to download an XML file of the results so they can use the data in Excel, etc. I do NOT want to write the file to the server first. I just want to be able to write the contents of the Dataset into a binary file and send it back out to the user as a download, but all in memory. Can you give me a boost in the right direction or an article that demonstrates this? Dan Hanover wrote: > I have an asp.net based report. I need the user to be able to download &g...

include busy/free time from "other" (i.e. ics) calendars
Please see the following thread. Is this possible? Could it be added as a future enhancement request? https://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.calendaring&mid=d5f088c7-77a7-48c5-8a9b-a1955f90aacc&sloc=en-us ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and t...

total of a range of times
This should be simple for some of you, but not for me. I am a runner, I have 4 ind. cells w/my split times. How do I get a total for the tallied times. I'm far from being experienced but am trying to learn..any and all help will be much appreciated. Thanks, Roger Roger To help you in your quest to "try to learn" I will direct you to Chip Pearson's site so's you can learn just about all you'll ever need for Time Calculations. http://www.cpearson.com/excel/datetime.htm#AddingTimes Gord Dibben Excel MVP On Sat, 13 Nov 2004 15:19:02 -0800, "Roger WG" &...

Autoformat dates and times
Hi, I have a workbook with two columns. In the formula bar of one of the cells i have 2005040101700 (YearMonthDateHoursMinutes), but what shows in the cell is 2.00504E+11 When I try to format the cell as yyyymmddhhmm I get ########### and when I put the cursor over the cell with ############### it says that negative dates and times are shown this way. How can I make this work? Thanks. Allison Allison, I'm hoping that your actual value is different: 2005040101700 doesn't make sense: year 2005 month 04 day 01 hour 01 minutes 70 seconds 0 Perhaps it's really 200504010...

How do I automatically plot different ranges of data in different.
I need to chart parameters that are a function of three variables in the 2002 version of Excel. I have used the x and y axis to represent 2 variables on an 'xy chart', but require an automatic method to represent the value of the third variable. I have tried the 'bubble-plot', but cannot get sufficient resolution between the data. Is their any way that I may plot the third variable in different colours/shades, that automatically changes for different ranges of the the third variable? THis might help you: http://www.peltiertech.com/Excel/Charts/format.html#CondChart &q...

Why does Outlook's message recall feature work sometimes but not all the time?
Basically my users have a problem with message recall. The problem is sometimes it works but most of the time it doesn't. Even more frustrating is when they get a successful recall notification message and then they get a reply to the message that was supposedly recalled successfully! Can anyone give me a straight answer or point me in the direction of a reliable article on message recall. www.winnetmag.com has an article that you have to pay for and Microsoft just explains how to use it. Thanks in advance, Chet Senior Customer Support Specialist Message recall is really unr...

Publisher 2007 will not open my old files
What to do? All of a sudden, my Publisher 2007 will not open any of my publisher files, even others done in publisher 2007. It crashes EVERY TIME. I have run Office Diagnostics twice, with no result. I have uninstalled and reinstalled Office 2007 TWICE, still no change. Do I just abandon it and go back to Publisher 2003? I've run virus scans, defragged, tried other versions of these files, tried files done by others - NOTHING works. it will start a new project, but will not open an old project without crashing. Can I install Publisher 2003 and use it even though I have Office ...

Downloaded transactions must be re-accepted every time
I bought Money 2005 last week and got it all set up. But when I turned on the auto-reconcile downloaded transactions option, I found that every transaction it pulled from my bank servers for the last month had to be re-accepted even though it had been downloaded, accepted, and reconciled. Turning this option off didn't fix the problem. It is very frustrating because I can't tell what's new and what's not now. It treats all my old dowloaded and reviewed transactions as something new. Anyone know why or how to fix it? In microsoft.public.money, BASIC since TRS-80 wro...

Operator Overload between different types
I'm trying to implement the overload for two different kinds of objects. I tryed for example: Dog1 + Dog2; Dog Dog::operator+(Dog& s) { return this->nBau + s.nBau; } it works fine. I need something... Dog1 + Cat1; ??? Dog::operator+(Cat& s) { return ???; } How can i implement my overload between different types and what type of object must return? I can only compile my program only specifing "return 0" in overload function but it doesn't work. Maybe i must implement overload function as static function outside class Dog? Some help please. My final n...

Automating Different Survey Results
Does anyone have any idea on how to facilitate the preparation of surve results? Our survey results are downloaded from our survey online facility (som facility when it can't even produce the report :sigh:). These survey are about the services of the different support groups of our company So each survey has its own set of questions. The backend process o translating these results is quite tedious and I've been thinking o how to automate it ... I know that there is a better way. I am usin Excel but only the standard features such as countif, sumproduct pivot, charts. But still it c...

different colors for x-Value axis
I want to use different colors for X-Values in X-axis of a chart. Is it possible? Example I-1, I-2 black II-1, II-2, II-3 grey III-1, III-2 red IV pink V-1, V-2, V-3 green -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan The best solution is that, Excel brings the formatting of x-axis value from source cell. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Khoshravan" wrote: > I want to use different colors for X-Values in X-axis of a chart. Is it > possible? > Example > I-1, I-2 black > II-1, II-2, II-3 grey > III-1, III-2 red > IV pink >...

What's the Difference Between This NG and microsoft.public.excel.misc?
See Subject. -- W. eWatson (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time) Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet Web Page: <www.speckledwithstars.net/> Hi, You are posting to the microsoft.public.excel so I'm not sure what you mean by the subject line? your's ends in .m which I don't think is a legal site. The microsoft Excel newgroup area has many sub-areas dealing with: Functions General Questions New users Charts Excel Application Errors Programming ...

Time total
Hello All, I need some help with creating a query to sum a total time of a field. I have a table called client services and have a query which pulls: date of service, total time, and provider name. I would like to be able to create a query which will sum the total time field. I have look at other posts on here but am still confused. Also not sure what time set to use: minutes or hour/minute format. Thanks for your help, -Mark Mark, I assume that you want to total time across clients, do you want to do it for a specific period, (June 07) or just get the total time? To get the total ...

rpc over http long logon time
How long should it take after Outlook starts before the prompt appears and asks for the password? Then afer that, how long before Outlook connects and starts downloading mail? Ours takes from 30 seconds to a minute for both steps. User are very confused why they start Outlook and have to enter their password a minute later, and still can't use Outlook for another minute. Thanks, Neal ...

Are there any significant differences in Excel 2003 from Excel 20.
I have some reference material for Excel 2002 and just wondering if it will be suitable for Excel 2003. Has anyone seen any significant differnces? Not really. You can read a review by MVP John Walkenbach on his website: http://www.j-walk.com/ss/excel/xl2003.htm HTH Jason Atlanta, GA >-----Original Message----- >I have some reference material for Excel 2002 and just wondering if it will >be suitable for Excel 2003. Has anyone seen any significant differnces? >. > ...