[AccessD] Pushing A2K Data to SQL2K - S-L-O-W!:

forgot to add

http://www-
3.ibm.com/software/data/informix/pubs/library/notes/relnotes/clientsdk2.htm


Martin



Quoting Ron Moore <rmoore at comtechpst.com>:

> John,		We are migrating away from Informix (not a dig against the
> multi-value architecture at all - I'll certainly miss some of it's
> strengths!).  I'm developing the migration/conversion processes because
> they
> have to be repeatable (multiple piloting runs).  And once we reach the
> go
> live date, I'll need the latest and greatest exports, and the legacy
> system
> is 'shut down'.
> 
> Best Regards,
> Ron
> 
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of John Bartow
> Sent: Tuesday, February 04, 2003 2:36 PM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Pushing A2K Data to SQL2K - S-L-O-W!:
> 
> 
> Are Informix and SQL server both going to be part of the final
> soulution
> with migration between the two being a regular process or is the goal
> to
> eliminate Informix?
> 
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Ron Moore
> Sent: Tuesday, February 04, 2003 1:08 PM
> To: accessd at databaseadvisors.com; dba-SQLServer at databaseadvisors.com
> Subject: [AccessD] Pushing A2K Data to SQL2K - S-L-O-W!:
> 
> 
> *cross-posted to SQL & Access Forums*
> 
> I'm migrating/converting data from an Informix DB to a SQLServer2K app
> using
> A2K as the middleware.  The final append query selects records from a
> buffer
> table and inserts them into a SQL table through an ODBC connection. 
> The
> push of the largest table takes almost 5 HOURS! :-((((   The Windows
> Task
> Manager shows A2K and the specific DB 'toggling' between 'Running' and
> 'Not
> Responding', but the process does finish.
> 
> 107,850 Records in A2K table.  72 Fields.  DB size (compressed before
> push)
> is 86Mb (was 346Mb).
> 
> Do I have to live with this lack of speed?  This is for a pilot which
> will
> be built from 'scratch' MANY times before it goes to production.
> 
> TIA,
> Ron Moore
> Sr. Database Administrator
> Comtech PST Corp.
> Melville,  NY
> www.comptechpst.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>