Re: performance question

2008-09-12 Thread walter harms
you mail like to find it by your self. simply use : explain query re, wh Yong Lee schrieb: All, Just curious as to which query would be better in terms of performance: select * from (select * from a union select * from b) as c; versus select * from a union select * from b; or would

Re: C++ cache MYSQL_RES

2008-09-12 Thread Warren Young
Kandy Wong wrote: Is there a way to cache the MYSQL_RES in C++? I've tried to develop a class with functions returning the MYSQL_RES, MYSQL_ROW and MYSQL_FIELDS. It sounds like you're trying to reinvent MySQL++: http://tangentsoft.net/mysql++/ -- Warren Young, maintainer of MySQL++

50% full text threshold

2008-09-12 Thread Fco. Mario Barcala
Hi all: I have been reading mysql 5.1 documentation and it says that default 50% threshold for natural language searches can be changed in storage/myisam/ftdefs.h but, what I have to change to allow indexing of all words? This percentage is not explicit in the file, so I don't know what I have

Re: Calculate total size of InnoDB tables?

2008-09-12 Thread ewen fortune
Hi, You can get that from the information_schema, check out this post from Peter Zaitsev http://www.mysqlperformanceblog.com/2008/03/17/researching-your-mysql-table-sizes/ Ewen On Fri, Sep 12, 2008 at 10:25 PM, Ryan Schwartz [EMAIL PROTECTED] wrote: Is there an easy way to calculate the