From: trevor@nospam.com   
      
   Hi all   
      
   We've had a Paradox 9 system running for years, 13 in fact.  It has been   
   sending data to and from an SQL 2000 database for 4 years without any issues   
   other than being slightly slow due to the nature of the SQL box also being   
   a File / Print server.   
      
   This box is Windows 2000.   
      
   Over the weekend our techies moved the SQL databases onto an all singing,   
   all dancing SQL server, still 2000 running Windowd 2003.   
      
   Since then, all our SQL access to the server has been slooooow!  I.e, taking   
   15-20 minutes to post a record when it used to take 30 seconds to a minute.   
      
   We're using native Paradox code to access these tables using Tcursors through   
   ODBC.   
      
   Can anyone shed any light as to why it has suddenly gone so slow considering   
   the new server is about 4 times better than the old?   
      
   I realise using TC's to read/write SQL tables is frowned upon (now I do!)   
   but it used to work fine on the old server.   
      
   We can find no major differences other than the CPU's (4 x Dual Core) compared   
   to old Dual Xeon and Windows (2k3 compared to 2k)   
      
   Please help if you can, I don't have much hair left and we're in the schtuck!   
      
   Thanks ever so much for any help!   
      
   Regards   
      
   Trevor   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)