Re: access via ado slow
From: JasonAu (JasonAu_at_discussions.microsoft.com)
Date: 10/28/04
- Next message: Jiho Han: "Performance comparison on Update vs. UpdateBatch - record by record"
- Previous message: Chris Lambert: "How to Supress ADO Domian warning in IE"
- Maybe in reply to: JasonAu: "access via ado slow"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 27 Oct 2004 18:01:01 -0700
Its the exact same database.
"Val Mazur" wrote:
> Hi,
>
> Is it the same database? In a case if your database is missing some indexes,
> which exist in a database, which works fine, you could experience some
> performance impact.
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "JasonAu" <JasonAu@discussions.microsoft.com> wrote in message
> news:CA6BC73D-13F0-4EDA-9D41-B319A77ACDCD@microsoft.com...
> > Hi,
> >
> > I'm running into speed problems retrieving data from an access 2k db using
> > an ADO jet ole db connection. On my local system, things run fine, but on
> > another system, it runs really slowly (when opening a recordset with a sql
> > select statement). I suspect some sort of system configuration to be the
> > culprit, as there were no problems about a week ago. I'm running win xp,
> > the
> > other system is running win 2003 server.
> >
>
>
>
- Next message: Jiho Han: "Performance comparison on Update vs. UpdateBatch - record by record"
- Previous message: Chris Lambert: "How to Supress ADO Domian warning in IE"
- Maybe in reply to: JasonAu: "access via ado slow"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
