Show All Projects

Showing 2 Projects Tagged OCGov

SyncFileAndXLS

Utility to minimize human intervention in correction discrepancies between file names and an XLS export of a database.

See more... (1 file, 1 screenshot)

CreateDummyFiles

Recreates the contents of a directory as zero-byte files from an HTML directory list to be able to make a zero-memory copy of folder structures. Superseded by a simpler utility for the same purpose: CopyDummyFiles.

See more... (1 file, 1 screenshot)

  URI STRING  
/listing/tag/OCGov
  CLASS/METHOD  
listing/tag
  MEMORY USAGE  
3,921,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0045
Controller Execution Time ( Listing / Tag )  0.0406
Total Execution Time  0.0452
  GET DATA  
No GET data exists
  POST DATA  
No POST data exists
  DATABASE:  smkprojects   QUERIES: 6   
0.0024   SELECT *
FROM (`Projects`)
INNER JOIN `ProjectTags` ON `Projects`.`ProjectID`=`ProjectTags`.`ProjectID`
WHERE `Projects`.`ProjectID` > 0
AND `Projects`.`ProjectID` > 0
AND `ProjectTags`.`Tag` = 'OCGov'
ORDER BY `Projects`.`Date` desc, `Projects`.`Date` desc 
0.0004   SELECT *
FROM (`ProjectTags`)
WHERE `ProjectID` = '18' 
0.0006   SELECT *
FROM (`ProjectResources`)
WHERE `ProjectID` = '18' 
0.0006   SELECT *
FROM (`ProjectTags`)
WHERE `ProjectID` = '13' 
0.0006   SELECT *
FROM (`ProjectResources`)
WHERE `ProjectID` = '13' 
0.0007   SELECT Tag, COUNT(1) AS cnt
FROM (ProjectTags)
WHERE `Tag` != 'Private'
GROUP BY Tag
HAVING COUNT(1) >1