Re: Has anyone found a Viable Solution?
Did you jump from 3.23 to 4.1? I thought MySQL likes us to go in steps -- 3.23 -> 4.0 -> 4.1 -> 5.0 with no skipping ahead. hmmm.
I do know that the SQL syntax changes from each version (no sub queries until 4.1 and logical ORs aren't really optimized until 5.0). but without the explain for these it's hard to tell what's going on. Maybe your indexes didn't get created?
If you're having problems with a query we need to see and explain plan for that query and a show create table(s)\G for the tables involved....
erin
Subject
Views
Written By
Posted
29794
August 11, 2005 11:25AM
24485
August 12, 2005 09:07AM
19735
August 12, 2005 01:06PM
19343
August 22, 2005 09:46AM
17401
August 24, 2005 03:27PM
13780
August 24, 2005 04:05PM
14492
August 26, 2005 11:02AM
8257
August 26, 2005 11:05AM
7653
August 26, 2005 11:45AM
7449
August 26, 2005 05:46PM
7743
August 26, 2005 10:34PM
7295
August 25, 2005 01:08PM
9033
August 26, 2005 11:07AM
6431
August 27, 2005 09:09AM
6809
August 29, 2005 11:50AM
6709
August 29, 2005 12:04PM
6092
August 29, 2005 12:55PM
6664
August 29, 2005 05:26PM
7980
August 29, 2005 06:34PM
5544
August 29, 2005 08:40PM
6950
August 29, 2005 08:47PM
5346
August 29, 2005 09:00PM
7783
August 30, 2005 10:05AM
5436
August 30, 2005 10:18AM
5937
August 30, 2005 10:20AM
6905
August 29, 2005 08:53PM
5949
August 29, 2005 09:50PM
5652
August 29, 2005 10:01PM
6145
August 30, 2005 08:53AM
5447
August 30, 2005 11:22AM
5984
August 30, 2005 11:33AM
5646
August 30, 2005 11:59AM
25231
August 31, 2005 02:32PM
7360
August 31, 2005 02:49PM
6177
August 31, 2005 02:56PM
8499
August 31, 2005 03:06PM
9225
December 07, 2006 10:30AM
5788
August 31, 2005 03:10PM
8314
August 31, 2005 03:32PM
18571
August 31, 2005 07:15PM
5995
September 01, 2005 03:05AM
8633
September 15, 2005 04:31PM
6548
September 01, 2005 04:39AM
5665
September 08, 2005 09:53AM
5781
September 08, 2005 11:25AM
6387
September 26, 2005 11:52AM
5402
September 26, 2005 12:13PM
5324
September 27, 2005 09:55AM
5362
September 27, 2005 10:18AM
4903
September 28, 2005 10:29AM
5065
September 28, 2005 10:34AM
5341
September 28, 2005 10:52AM
5687
September 28, 2005 10:58AM
13160
September 23, 2005 01:56AM
5744
September 23, 2005 07:11AM
8866
October 05, 2005 04:58AM
Re: Has anyone found a Viable Solution?
7068
October 05, 2005 04:52PM
8049
October 05, 2005 11:49PM
6521
October 06, 2005 01:34AM
8780
October 06, 2005 04:57PM
5565
December 13, 2005 10:28AM
5444
December 13, 2005 10:34AM
5319
November 17, 2005 09:39AM
6722
January 08, 2007 12:12PM
5578
December 12, 2005 02:13PM
5559
December 14, 2005 11:43PM
7423
December 15, 2005 08:37AM
5648
December 15, 2005 11:18AM
7592
December 15, 2005 11:27AM
6406
December 15, 2005 11:32AM
4874
December 15, 2005 11:43AM
7561
December 15, 2005 11:43AM
5067
December 15, 2005 11:48AM
4918
December 15, 2005 11:51AM
6120
December 15, 2005 02:14PM
6084
December 15, 2005 02:18PM
4881
December 15, 2005 02:27PM
7439
December 15, 2005 02:43PM
4807
December 15, 2005 08:46AM
5819
January 26, 2006 12:38PM
4988
January 26, 2006 01:48PM
7149
January 26, 2006 01:48PM
4775
January 26, 2006 01:52PM
4963
January 27, 2006 04:46PM
7132
January 29, 2006 11:21AM
7853
January 30, 2006 09:42AM
5543
February 27, 2006 02:17PM
7561
February 27, 2006 02:23PM
5124
March 05, 2006 04:56AM
5916
March 06, 2006 08:09AM
4937
April 05, 2006 01:03PM
6136
September 27, 2006 08:43AM
6837
November 19, 2006 04:42AM
5466
December 14, 2006 05:45PM
4988
February 01, 2007 04:40AM
5758
November 11, 2007 01:24PM
7030
December 20, 2007 10:40AM
7322
January 21, 2008 10:14AM
6689
January 21, 2008 10:53AM
6609
May 19, 2008 09:41AM
7490
February 05, 2008 10:27AM
6887
March 12, 2008 08:37AM
6169
May 19, 2008 03:02AM
6888
November 14, 2008 12:31AM
7961
March 06, 2009 03:36PM