large query result caching (using C API)

MySQL 4.1.0-alpha-max-nt MySQL C API interface Visual C++ 6.0 trying some query when cache is on... it causes ERROR: "Lost connection to MySQL sever during query" MySQL cache memory used for _this_ query ~900Kb but when cache is off or query result size is less than few Kb, everything is OK. WHY

mysql error

Hello mysql, MySQL 4.1.0-alpha-max-nt phpMyAdmin 2.5.4 /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL default '', UNIQUE KEY `i

Re[2]: Tree-like structure: make it simply

Hello Matthew, Friday, December 5, 2003, 2:12:08 AM, you wrote: thanks, but some more see below. [skipped] >> I have some table: >> /* BEGIN DUMP */ >> CREATE TABLE `sp_tovar_vid` ( >> `id` int(11) NOT NULL auto_increment, >> `id_tovar_vid` int

Tree-like structure: make it simply

Hello mysql, I have some table: /* BEGIN DUMP */ CREATE TABLE `sp_tovar_vid` ( `id` int(11) NOT NULL auto_increment, `id_tovar_vid` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `description` varchar(255) NOT NULL def