Database

kenn_rosie wrote:

I created the sub SortEventHandler as below but I am lost as to
what is next to do?

BadKarma wrote:

Updating those 20K (20000) records one at the time consumes a lot of time.
In order to speed things up I collect those queries to create one big SQL statement.

Now the problem is the following whenever I place more that 455 update queries only the
first 455 are executed. The others are neglected, because no error has happened (neighter

Dave Kreskowiak wrote:

if one statement fails, you have to consider the entire batch a failure

UPDATE MyTable SET MyField = 1 WHERE Data = 1;
UPDATE MyTable SET MyField = 1 WHERE Data = 2;
UPDATE MyTable SET MyField = 1 WHERE Data = 3;
UPDATE MyTable SET MyField = 1 WHERE Data = 4;

BadKarma wrote:

So like you can see the size of the query is relative small not even 50 characters.
The batch statement though, can reach the size of more the 20k of characters but shouldn't be

CREATE TABLE Types (
       TypeID INTEGER PRIMARY KEY
     , TypeInfo CHAR(125)
);

CREATE TABLE Templates (
       TemplateID INTEGER PRIMARY KEY
     , TemplateSignature CHAR(125)
);

CREATE TABLE Files (
       FileID INTEGER PRIMARY KEY
     , Path CHAR(255)
);

CREATE TABLE Symbols (
       Id INTEGER PRIMARY KEY
     , Kind INTEGER
     , Name CHAR(125)
     , FileID INTEGER
     , TypeID INTEGER
     , Offset INTEGER
     , LineNumber INTEGER
     , TemplateID INTEGER DEFAULT 0 NOT NULL
     , Parent INTEGER DEFAULT 0
);

CREATE TABLE Functions (
       FuncID INTEGER PRIMARY KEY
     , Signature CHAR(125)
     , SymbolID INTEGER
     , ReturnTypeID INTEGER NOT NULL
);

select symbols.name,functions.signature from symbols, functions where
  functions.symbolid = symbols.id;

class AClass {<br />
  string name;<br />
  int offset;<br />
  ...<br />
}

CLASS AClass TABLE CLASSES<br />
  PRIMARY_KEY name<br />
;<br />
<br />
CLASS AUnion TABLE UNIONS<br />
  PRIMARY_KEY name<br />
;

  // oid below can be built dynamically using program variables<br />
  Object oid = ObjectId.createObjectId("AUnion;name=someUnion");<br />
  AUnion myUnion = njdx.getObjectById(oid, true, 0, null);

jszpila wrote:

As perviously mentioned the query is huge so I'd like to avoid using a union if at all possible, just to reduce clutter

SELECT dateColumn, 
       ABS(DATEDIFF(minute, dateColumn, @distanceFromThisTime)) AS TimeDifference,
       CASE WHEN dateColumn IS NULL THEN 0 ELSE 1 END AS Nothing
FROM myTable
ORDER BY CASE WHEN dateColumn IS NULL THEN 0 ELSE 1 END DESC, 
         ABS(DATEDIFF(minute, dateColumn, @distanceFromThisTime)) ASC