home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,192 of 9,834   
   Leslie Milburn to Trevor   
   Re: SQL access very slow in Paradox 9 HE   
   01 May 08 22:09:55   
   
   From: CDB4W@NOSPAM.bigpond.com   
      
   "Trevor"  wrote in message   
   news:4819824d$1@pnews.thedbcommunity.com...   
   >   
   > Hi Leslie   
   >   
   > We're definitely using TCP/IP only.  Have been for years.  We've not used   
   > Netbeui since the old netware days if I recall.   
   >   
   > The thing is, the Access apps are also using ODBC to the same server and   
   > they are not slow.   
   >   
   > Only Paradox :(   
   >   
   > Trevor   
      
   Here are some more suggestions:   
      
   1.  Have you changed any of the workstations in any way and I include   
   upgrading to Office 2007 as a potential problem.   
      
   2. Do you operate a common BDE on the server or is it per workstation. If   
   common and on the server, did you retain/transfer the original idapi.cfg   
   file   
      
   3. If a common BDE on the server is being used, did you upgrade it by any   
   chance to the latest 5.2.2 - if so there is a performance issue with   
   International Language when compared with the BDE 4.5   
      
   4. Was the drive that has got the database previously FAT32 and is now   
   perhaps NTFS ?   
      
   5. If you still can hook up the old server then I suggest you enable ODBC   
   logging and perform the same sequence of events of both databases and then   
   compare the logs. At lease this way you can be sure that the commands being   
   sent are identical.   
      
   6. Grasping ...... double check the Windows Language settings - this can   
   cause issues with Date based queries (a real clutch at straws this one !!).   
      
   Leslie.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca