Have you tried an alternative to MS? Try using something lightweight like GPs ODBC Query Tool: http://gpoulose.home.att.net/ and see if you still run into performance problems. (Also, make sure that you have ODBC Tracing turned off!) Good luck, Stuart
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Jeremy Woods > Sent: Wednesday, 11 August 2004 16:14 > To: [EMAIL PROTECTED] > Subject: [U2] Universe 10.1.1 ODBC driver > > > Hello group > > I am trying to access some SQL tables created in universe via ODBC with > microsoft access but retreiving the data is very slow - about 2 minuted to > retrieve 91 records with approximately 20 columns of data. > > We have tried running the same query on our HP machine and then a Linux > machine - same results. The tables have been setup in a Schema and have > been created using the CREATE TABLE keywords. If I do the same select > statement at TCL it is very quick to display the data so I assume it is > something to do with the universe ODBC driver. > > Anyone experienced this before ? > > Regards > Jeremy Woods > Western QBE Insurance > Perth IT > (08) 9213 6398 > > ________________________________________________________________________ > IMPORTANT NOTICE : The information in this email is confidential > and may also > be privileged. If you are not the intended recipient, any use or > dissemination > of the information and any disclosure or copying of this email is > unauthorised > and strictly prohibited. If you have received this email in error, please > promptly inform us by reply email or telephone. You should also > delete this > email and destroy any hard copies produced. > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ********************************************************************** ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
