Thanks to Peter and Mikael Lund - the trace feature had indeed been enabled. Turned it off and now all is well!
Thanks again. Ollie -----Original Message----- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: 17 December 2003 11:48 To: Oliver Prudden; [EMAIL PROTECTED] Subject: RE: MI-L extremely slow live DBMS Make sure that you haven't enabled the trace feature on the ODBC Administrator dialog. This can give the mentioned results, because every ODBC activity is logged to a file. Peter Horsbøll Møller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk *****CHANGE OF ADDRESS - COWI's offices in Odense are now under the same roof***** On December 8th. 2003, Geographical Information & IT moved from Rugaardsvej 55, 5000 Odense C to Odensevej 95, 5260 Odense S. Please note our new telephone, direct and telefax numbers. COWI wish you a merry Christmas and a happy New Year. > -----Original Message----- > From: Oliver Prudden [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 17, 2003 11:39 AM > To: [EMAIL PROTECTED] > Subject: MI-L extremely slow live DBMS > > > Hi all, > > > > I have a live DBMS connection to a MS Access database that is > unreasonably slow to the point of being unusable. For example > the browser window opens one record at a time and takes over > 1 second per record... Whilst any live table is opening, or > if I move through records in a browser window, there is also > a tremendous amount of hard disc activity on my computer, but > no increase in other resource usage. > > The same DBMS connection (file DSN) is fine on my colleague's > computer with exactly the same software setup as me. > > I have MI v 7.5, Win2k and Access2002 on a dual processor > 2.4GHz Pentium with 1Gb ram. The database is stored on our > office server and we have a 100Mbps network. I have tested > my network connection, reinstalled MapInfo and reinstalled > the DBMS support which hasn't solved anything. > > > > Any suggestions? > > > > Ollie > This Electronic Transmission is intended only for the > attention of the addressee. It may contain privileged and > confidential information. If you are not the person for whom > it is intended, you must not copy, distribute or take any > action in reliance on it. If you have received this > electronic transmission in error please notify us immediately > by telephone, delete the transmission and destroy any hard copies. > Nicholas Pearson Associates has used all reasonable efforts > to ensure that this message and any attachments are free from > viruses. > Nicholas Pearson Associates > Environmental Planners - Landscape Architects - Ecologists > 30 Brock Street, Bath BA1 2LN > Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387 > This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates Environmental Planners - Landscape Architects - Ecologists 30 Brock Street, Bath BA1 2LN Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387
