Re: Memory Problem with 1 DB. Other DB ok

[Gabriel Dunn]

A Linked Server uses ODBC to connect from Microsoft SQL Server to a variety of other platforms, in my case a Linux based MySQL database.

This process was working for a week, and still works for small datasets. And sometimes for the full set if queried from a different MySQL database... but not always.

The table has about 450,000 rows.

The query I am running only selects the ID column, not all the columns. I want to load it into a temporary MSSQL table, stored in MSSQL memory. Then I compare the temp table in MSSQL against the primary member table in MSSQL. Any records in MSSQL, but not in the temp table from MySQL, are then inserted into MySQL via the linked server again.


The table structure is:

CREATE TABLE `wp_users` (
`ID` bigint(20) unsigned NOT NULL,
`user_login` varchar(60) NOT NULL default '',
`user_pass` varchar(64) NOT NULL default '',
`user_nicename` varchar(50) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_url` varchar(100) NOT NULL default '',
`user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
`user_activation_key` varchar(60) NOT NULL default '',
`user_status` int(11) NOT NULL default '0',
`display_name` varchar(250) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`),
KEY `ID_Desc` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;