add alternative sql statements
diff --git a/data.go b/data.go
index 1b3182f..0a3ea83 100644
--- a/data.go
+++ b/data.go
@@ -125,6 +125,8 @@
func (dbc *dbManager) getReadyDeployments() ([]DataDeployment, error) {
+ // An alternative statement is in get_ready_deployments.sql
+ // Need testing with large data volume to determine which is better
rows, err := dbc.getDb().Query(`
SELECT a.id,
a.organization_id,
diff --git a/get_ready_deployments.sql b/get_ready_deployments.sql
new file mode 100644
index 0000000..58b5fae
--- /dev/null
+++ b/get_ready_deployments.sql
@@ -0,0 +1,56 @@
+SELECT a.id,
+ a.organization_id,
+ a.environment_id,
+ a.bean_blob_id,
+ a.resource_blob_id,
+ a.type,
+ a.name,
+ a.revision,
+ a.path,
+ a.created_at,
+ a.created_by,
+ a.updated_at,
+ a.updated_by
+ FROM metadata_runtime_entity_metadata as a
+ INNER JOIN edgex_blob_available as b
+ ON a.resource_blob_id = b.id
+ WHERE a.resource_blob_id != ""
+ INTERSECT
+ SELECT a.id,
+ a.organization_id,
+ a.environment_id,
+ a.bean_blob_id,
+ a.resource_blob_id,
+ a.type,
+ a.name,
+ a.revision,
+ a.path,
+ a.created_at,
+ a.created_by,
+ a.updated_at,
+ a.updated_by
+ FROM metadata_runtime_entity_metadata as a
+ INNER JOIN edgex_blob_available as b
+ ON a.bean_blob_id = b.id
+ WHERE a.resource_blob_id != ""
+ UNION
+ SELECT a.id,
+ a.organization_id,
+ a.environment_id,
+ a.bean_blob_id,
+ a.resource_blob_id,
+ a.type,
+ a.name,
+ a.revision,
+ a.path,
+ a.created_at,
+ a.created_by,
+ a.updated_at,
+ a.updated_by
+ FROM metadata_runtime_entity_metadata as a
+ INNER JOIN edgex_blob_available as b
+ ON a.bean_blob_id = b.id
+ WHERE a.resource_blob_id = ""
+ )
+
+ ;
\ No newline at end of file
