Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 9 of 9 total |
EDBManager - sql progress / time |
Sat, Jan 19 2008 8:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Not sure what I'd expect, but I get no execution plan for the statement below. Nor is there any indication of progress just an uncomfortable wait.
Roy Lambert CREATE TABLE xTable AS SELECT FALSE AS _Selected, _fkContacts, _fkCompanies, _Surname, _Forename, (_Forename+' '+_Surname) AS _xContactName, IF(_EMail IS NOT NULL,_EMail,_HomeEMail) AS _xEMail, _EMail, _HomeEMail, _JobTitle, _Name AS _CompanyName, _Left, _NoEshots FROM "NLH-Live".Contacts T0 JOIN "NLH-Live".Career ON Career._fkContacts = _ID JOIN "NLH-Live".Companies ON Companies._ID = Career._fkCompanies WITH DATA |
Sat, Jan 19 2008 12:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Not sure what I'd expect, but I get no execution plan for the statement below. Nor is there any indication of progress just an uncomfortable wait. >> You won't get either since ultimately the operation is a CREATE TABLE, not a SELECT. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jan 19 2008 1:21 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Execution plan I can live without since I can use just the select to create one and see how its doing but I would like a progress indicator for the with data bit which can take a while so it would be nice to let people know there's something happening. Roy Lambert |
Sat, Jan 19 2008 2:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Execution plan I can live without since I can use just the select to create one and see how its doing but I would like a progress indicator for the with data bit which can take a while so it would be nice to let people know there's something happening. >> I'll see what I can do, but the two are in different categories of statement execution, so it may not work. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Jan 28 2008 9:09 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Any news on this before I start splitting up my memory table CREATE AS WITH DATA into a WITH NO DATA and a separate INSERT INTO? Roy Lambert |
Mon, Jan 28 2008 3:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Any news on this before I start splitting up my memory table CREATE AS WITH DATA into a WITH NO DATA and a separate INSERT INTO? >> New features only come out for minor releases, and right now I can't say when the next minor release will be. There's a lot of new features on the list currently, and I'm thinking that it's getting close to EDB v2 time. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jan 29 2008 4:12 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< Any news on this before I start splitting up my memory table CREATE AS >WITH DATA into a WITH NO DATA and a separate INSERT INTO? >> > >New features only come out for minor releases, and right now I can't say >when the next minor release will be. There's a lot of new features on the >list currently, and I'm thinking that it's getting close to EDB v2 time. Ignoring the timetable is it liable to happen, I know you had some reservations? If so I'll leave the statements alone, if not I'll start splitting them. Roy Lambert |
Tue, Jan 29 2008 3:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Ignoring the timetable is it liable to happen, I know you had some reservations? If so I'll leave the statements alone, if not I'll start splitting them. >> I should be able to make an exception for the CREATE TABLE statement. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jan 30 2008 4:09 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
OK, if its not going to happen let me know and I'll split the statements up. Its a simple cut'n'paste so no big deal. Roy Lambert |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |