Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raj_sqlteam
Starting Member
1 Post |
 Posted - 2009-12-24 : 04:57:54
|
| Hi,I have an vb6 application which captures some employee performance information and update in a mssql 2000 table as well as in a mysql table. I am using procedures to update in mssql 2000 and the openquery component to insert/update data into the mysql table through mssql 2000. The client app will hit an update query say for a minimum of every 2-3 seconds which is affecting the performance. I am using a ML530 server with 4 GB RAM, 2.8 Ghz with RAID 5.Is there a better way to do this?Please suggest.Rajkumar |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-12-24 : 05:17:12
|
| Post SQL code & related table structures...see our FAQ's. |
 |
|
|
|
|
|
performance issue with openquery