I had following problem, I must copy table one to table two and use a statement like this:
INSERT INTO A SELECT field_a FROM B Ok it's runs fine, But sometimes i had the problem thats the blob (LONG(ASCII)) not 100% correct (ca all 5 - 10k poies) Why thats? I there an alternaive to copy table in java? --------------------------------------------------------- Ok second problem, How can I speed up my database? I had one table with many entray (more than 10 Millions) and the search take such a long time and whenever i had new entry the perfomece slow down... What can I do? To change this slow down problem problem or speed my database up? Cheers gert Gert Wohlgemuth Max Plack Institut f�r Molekulare Pflanzenphysiologie Am M�hlenberg 1 14424 Golm Fon: +49-331-5678320 e-mail: [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
