Re: merge multiple databases

From: YYZ (notapplicable)
Date: 05/14/04 

Date: Fri, 14 May 2004 09:08:35 -0500

"DIOS" <sindizzy.pak@softhome.net> wrote in message
news:j8Yoc.44452$536.7869399@attbi_s03...
> My results were astonishing. As YYZ commented the SQL version was way
> faster.
> Here are my results:
>
> Test applied to merging 8 databases with three tables each. 4 medium sized
> databases
> and 4 small databases. Four runs were applied and the times were avearged.
>
> Record Looping method: 410 seconds
> SQL UPDATE method: 57 seconds
>
> The record looping method had more status updates via a label but the
> difference wa still
> heavily favoring the SQL method.

Glad to hear it. Sometimes I think that it is more important to let the user
know what is happening rather than speeding a process up, but in this case those
results seem to be too dramatic to go back.

I would recommend 1 of 2 approaches. You may be able to still show realtime
statuses if you execute the queries asynchronously. I've never done it myself,
and it may not work out like I think it will, but I'd look into it. I tried to
do it for you, but my ADO help is trashed for some reason, and I don't have time
to look it up on MSDN right now.

Or, you can show an animation while it's going.
http://vbaccelerator.com/home/VB/Code/Controls/AVI_Player/ComCtl32_AVI_Player/ar
ticle.asp

I use that all the time in my current application.

Matt

Relevant Pages

  • Re: merge multiple databases
    ... As YYZ commented the SQL version was way ... Test applied to merging 8 databases with three tables each. ... The record looping method had more status updates via a label but the ...
    (microsoft.public.vb.database.dao)
  • Re: merge multiple databases
    ... As YYZ commented the SQL version was way ... Test applied to merging 8 databases with three tables each. ... The record looping method had more status updates via a label but the ...
    (microsoft.public.vb.general.discussion)
  • Re: merge multiple databases
    ... As YYZ commented the SQL version was way ... Test applied to merging 8 databases with three tables each. ... The record looping method had more status updates via a label but the ...
    (microsoft.public.access.queries)
  • Re: merge multiple databases
    ... As YYZ commented the SQL version was way ... > and 4 small databases. ... > SQL UPDATE method: 57 seconds ... > The record looping method had more status updates via a label but the ...
    (microsoft.public.access.queries)
  • Re: merge multiple databases
    ... As YYZ commented the SQL version was way ... > and 4 small databases. ... > SQL UPDATE method: 57 seconds ... > The record looping method had more status updates via a label but the ...
    (microsoft.public.vb.general.discussion)
Loading