Re: Which AMD Dual Core Processor?

2006-09-01 Thread Lexington Luthor
mos wrote: I'm thinking of upgrading my AMD3500 to a dual core AMD processor. Is there any noticeable difference between these? AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache) AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache) AMD Athlon 64X2 4400+ Dual Core S939 Toled

Re: Text search + transactions?

2006-08-07 Thread Lexington Luthor
Peter Zaitsev wrote: Right. If you want full text search to follow transaction isolation as well you're in trouble.In most search applications however it is not that critical. Thats a pity. I will have to port the application to PostgreSQL then. Thanks anyway, LL -- MySQL General

Re: Text search + transactions?

2006-08-07 Thread Lexington Luthor
Peter Zaitsev wrote: Hi, One of approaches is to have "shadow" MyISAM table in addition to your Innodb table to perform full text search, which you can update in bulks or via triggers. How can I ensure isolation for queries on this "shadow" table? The documentation says that the table type d

Text search + transactions?

2006-08-07 Thread Lexington Luthor
Hi, I need fast text searching on a transactional table. Is it possible to use transactions and text-search on a table together yet in any production stable version of mysql? Thanks, LL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l