Re: Why does query load faster after executing 2nd time? (Query Caching DISABLED, Key-Cache already fully loaded)

2005-07-17 Thread sam . deforest
Hello therei have seen this question before, I cannot exactly remember when but it was a while ago. My advice is to go to the mysql.com website and do a search thru the mailing list using a search term something like "must execute query twice" or something to that effect. -sam > Filesystem bu

Re: more queries vs a bigger one

2005-07-17 Thread sam . deforest
Hello, approx. how long does it take your "big" query to run as it is now? Are these queries appending a table? or are they buiding a result (from a "chain" of queries)? Have you tried separating them out? Any difference? -sam > Hi, > > I have a big query that involves searching in more tables

RE: datetime/timestamps/4.1.12

2005-07-17 Thread sam . deforest
Mike, Have you tried creating a new table with a field for some sort of date? Try adding some data and see if the new date time format you specified in the my.cnf file. See if that works. -sam > Hello, > > Nevermind - duh -datetime is not timestamp (oneday I fullfill my promise > to myself and n