We've had a Paradox 9 system running using SQL 2000 for years. We only write to SQL for Intermediate tables for other systems.
It's always been a tad slow writing to SQL mainly because the server not just ran SQL but also File and Print.
We've moved the SQL databases to a new dedicated SQL server which is fast as hell.... However, when Paradox is accessing the server it hangs for like 20 minutes
Any ideas as to why this would be? We can query with SQL Enterprise Manager no problem, it's only when Paradox is accessing the records. We've never come across anything like this before and it's causing some major grief on the system!
it's not just Paradox Queries that fail / lock up but also Tcursors, especially when doing a locate
tcursors on the paradox tables?.. I thought you meant you were having problems accessing the SQL data..
well, the timing could be a coincidence, if the following is the source:
paradox indexes become problematic when the table size gets past 1/2 of the potential max size, for the current block size.. i.e. 2K blocks allow max table size of 128 meg, and issues start at 64 meg of data.. and with heavy fragmentation, that point could come sooner..
Steven Green - Myrtle Beach, South Carolina USA