Gert Wohlgemuth wrote: > 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?
For the first problem I need more input. What's going wrong and how can I reproduce it? For the second one I only can suggest to create indexes or primary keys which will support your queries. Additionally you could check the data cache hitrate and if necessary increase the database parameter CACHE_SIZE. Best regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
