Yeah, the problem is that in order to make all those columns sortable I had to do some complex queries (i.e. sub queries inside a SELECT statement). You brought this to my attention a while back Torgos, I just never got around to come up with a more efficient way to query for all this aggregate data. A quick fix would be to ditch sorting for certain columns. I'm still up in the air to do about this, I'd like to revisit this after I take care of a few other issues.
Re: Re: Re: Re: Re: Re: Re: Re: my bad
uc_reports (38 replies) Thu, 11/08/2007 - 16:20
- dates not incrmenting properly (12/13/2007 - 11:31)
- Re: dates not incrmenting properly (12/13/2007 - 11:58)
- Re: dates not incrmenting properly (12/13/2007 - 11:52)
- my bad (12/18/2007 - 16:31)
- Re: my bad (12/19/2007 - 09:05)
- Re: Re: my bad (01/16/2008 - 17:23)
- Re: Re: Re: my bad (01/16/2008 - 18:18)
- Re: Re: Re: Re: my bad (01/23/2008 - 11:48)
- Re: Re: Re: Re: Re: my bad (01/23/2008 - 15:06)
- Re: Re: Re: Re: Re: Re: my bad (01/25/2008 - 12:46)
- Re: Re: Re: Re: Re: Re: Re: my bad (01/25/2008 - 12:53)
- Re: Re: Re: Re: Re: Re: Re: Re: my bad (01/25/2008 - 13:11)
- state/zone custom option (01/25/2008 - 14:37)
- Re: state/zone custom option (01/25/2008 - 15:36)
- Re: Re: state/zone custom option (01/25/2008 - 16:25)
- Re: Re: Re: state/zone custom option (01/25/2008 - 16:37)
- Re: Re: Re: Re: state/zone custom option (01/28/2008 - 10:04)
- Re: Re: Re: Re: Re: state/zone custom option (01/28/2008 - 12:02)
- Re: Re: Re: Re: Re: Re: state/zone custom option (01/28/2008 - 14:12)
- Re: Re: Re: Re: Re: Re: Re: state/zone custom option (01/28/2008 - 15:48)
- Re: Re: Re: Re: Re: Re: Re: Re: state/zone custom option (02/05/2008 - 11:29)
- Re: Re: Re: Re: Re: Re: Re: Re: Re: state/zone custom option (04/09/2008 - 10:38)
- Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: state/zone custom option (04/18/2008 - 18:30)
- Re: Re: Re: Re: Re: Re: Re: Re: Re: state/zone custom option (04/09/2008 - 10:38)
- Re: Re: Re: Re: Re: Re: Re: Re: state/zone custom option (02/05/2008 - 11:29)
- Re: Re: Re: Re: Re: Re: Re: state/zone custom option (01/28/2008 - 15:48)
- Re: Re: Re: Re: Re: Re: state/zone custom option (01/28/2008 - 14:12)
- Re: Re: Re: Re: Re: state/zone custom option (01/28/2008 - 12:02)
- Re: Re: Re: Re: state/zone custom option (01/28/2008 - 10:04)
- Re: Re: Re: state/zone custom option (01/25/2008 - 16:37)
- Re: Re: state/zone custom option (01/25/2008 - 16:25)
- Re: state/zone custom option (01/25/2008 - 15:36)
- state/zone custom option (01/25/2008 - 14:37)
- Re: Re: Re: Re: Re: Re: Re: Re: my bad (01/25/2008 - 13:11)
- Re: Re: Re: Re: Re: Re: Re: my bad (01/25/2008 - 12:53)
- Re: Re: Re: Re: Re: Re: my bad (01/25/2008 - 12:46)
- Re: Re: Re: Re: Re: my bad (01/23/2008 - 15:06)
- Re: Re: Re: Re: my bad (01/23/2008 - 11:48)
- Re: Re: Re: my bad (01/16/2008 - 18:18)
- Re: Re: my bad (01/16/2008 - 17:23)
- Re: my bad (12/19/2007 - 09:05)
- my bad (12/18/2007 - 16:31)
- Re: uc_reports (11/27/2007 - 10:37)
- Re: Re: uc_reports (11/28/2007 - 10:16)
- Ok
I'll have to think how (11/29/2007 - 13:21)
- Re: Ok
I'll have to think how (11/29/2007 - 13:48)
- Re: Re: Ok I'll have to think how (12/03/2007 - 04:32)
- Re: Ok
I'll have to think how (11/29/2007 - 13:48)
- Ok
I'll have to think how (11/29/2007 - 13:21)
- Re: Re: uc_reports (11/27/2007 - 10:38)
- Re: Re: uc_reports (11/28/2007 - 10:16)
- Re: uc_reports (11/20/2007 - 22:35)
- xerbutter,
thanks for the (11/21/2007 - 09:30)
- Re: xerbutter, thanks for the (11/21/2007 - 10:57)
- xerbutter,
thanks for the (11/21/2007 - 09:30)
- sales report calculations (11/13/2007 - 11:17)
- Re: sales report calculations (11/13/2007 - 14:45)
- Re: Re: sales report calculations (11/13/2007 - 15:03)
- Re: Re: Re: sales report calculations (11/13/2007 - 15:36)
- Nice work, Shawn!
Thanks for (11/20/2007 - 20:12)
- Mariano, There should be a (11/21/2007 - 09:11)
- Nice work, Shawn!
Thanks for (11/20/2007 - 20:12)
- Re: Re: Re: sales report calculations (11/13/2007 - 15:36)
- Re: Re: sales report calculations (11/13/2007 - 15:03)
- Re: sales report calculations (11/13/2007 - 14:45)
|
|



Joined: 08/07/2007