Show All Projects

Showing 1 Project Tagged Oracle

KTM Oracle Test

Diagnostic tool for testing Oracle tables and views with Kofax Transformation Modules.

See more... (2 files, 1 screenshot)

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Listing / Tag )  0.0106
Total Execution Time  0.0125
  GET DATA  
No GET data exists
  MEMORY USAGE  
822,000 bytes
  POST DATA  
No POST data exists
  URI STRING  
listing/tag/Oracle
  CLASS/METHOD  
listing/tag
  DATABASE:  smkprojects (Listing:$db)   QUERIES: 4 (0.0030 seconds)  (Hide)
0.0012   SELECT *
FROM `Projects`
INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID`
WHERE `Projects`.`ProjectID` >0
AND `Projects`.`ProjectID` >0
AND `ProjectTags`.`Tag` = 'Oracle'
ORDER BY `Projects`.`Date` DESC, `Projects`.`Date` DESC 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '22' 
0.0004   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '22' 
0.0009   SELECT Tag, COUNT(1) AS cnt
FROM `ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 1 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)