Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Paradox > SQL access very...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 14 Topic 1360 of 1389
Post > Topic >>

SQL access very slow in Paradox 9 HELP!

by "Trevor" <trevor@[EMAIL PROTECTED] > Apr 29, 2008 at 06:54 AM

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
 




 14 Posts in Topic:
SQL access very slow in Paradox 9 HELP!
"Trevor" <tr  2008-04-29 06:54:07 
Re: SQL access very slow in Paradox 9 HELP!
"Leslie Milburn"  2008-04-29 23:17:25 
Re: SQL access very slow in Paradox 9 HELP!
"Trevor" <tr  2008-04-29 10:45:27 
Re: SQL access very slow in Paradox 9 HELP!
"Jim Moseley" &  2008-04-29 13:43:08 
Re: SQL access very slow in Paradox 9 HELP!
"Larry DiGiovanni&qu  2008-04-29 13:47:45 
Re: SQL access very slow in Paradox 9 HELP!
"Trevor" <tr  2008-04-30 03:44:33 
Re: SQL access very slow in Paradox 9 HELP!
Bill McCray <McCrayBil  2008-04-30 06:33:10 
Re: SQL access very slow in Paradox 9 HELP!
"Trevor" <tr  2008-05-01 04:38:24 
Re: SQL access very slow in Paradox 9 HELP!
"Leslie Milburn"  2008-04-30 20:11:00 
Re: SQL access very slow in Paradox 9 HELP!
"Trevor" <tr  2008-05-01 04:41:49 
Re: SQL access very slow in Paradox 9 HELP!
"Leslie Milburn"  2008-05-01 22:09:55 
Re: SQL access very slow in Paradox 9 HELP!
"Trevor" <tr  2008-05-07 05:58:52 
Re: SQL access very slow in Paradox 9 HELP!
"|-| /-\\ |_ \(\)7   2008-04-30 22:52:41 
Re: SQL access very slow in Paradox 9 HELP!
SimonW <Simon@[EMAIL P  2008-05-01 10:09:33 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 0:35:31 CDT 2008.