Also, are you pushing or pulling the data?

Also, apparently you did NOT eliminate the Assign() calls. You should do
this. They are not an efficient way to transfer the data as I already
explained.

Be sure to include your database and tell me which version of server and
client you are using to connect.

Thanks,
Jason Wharton

----- Original Message -----
From: "Hans" <hhoogstraat@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, March 21, 2010 3:56 PM
Subject: Re: [IBO] development


> Hello Jason,
>
> As requested I performed all the requested tests with a greatly in size
> reduced database
>
> IBOjects:
> Test 1:
> 15:30:28.500 DataPumping using IBObjects
> 15:30:28.500 Using two IB_Cursors
> 15:32:40.406 Database Maint Completed in 124.579 Secs
>
> Test 2:
> 15:38:47.500 DataPumping using IBObjects
> 15:38:47.500 Using Begin/End Busy
> 15:38:47.500 Using two IB_Cursors
> 15:40:47.125 Database Maint Completed in 111.734 Secs
>
> Test 3:
> 15:41:11.015 DataPumping using IBObjects
> 15:41:11.015 Using IB_DataPump (Yield = False)
> 15:43:09.953 Database Maint Completed in 111.578 Secs
>
> Test 4:
> 15:44:31.875 DataPumping using IBObjects
> 15:44:31.875 Using Begin/End Busy
> 15:44:31.875 Using IB_DataPump (Yield = False)
> 15:46:24.953 Database Maint Completed in 105.687 Secs
>
> FIBPlus:
>
> 15:22:27.718 DataPumping using FIBPlus
> 15:22:27.718 Using two tpFIBDataSets
> 15:22:48.843 Database Maint Completed in 13.812 Secs
>
> Sorry to disappoint you :)
>
> Source Code available upon request, which consists of a 6 line assign loop
> or a one line IB_DataPump.Execute
> plus some bookkeeping.
>
> Best Regards
> Hans