in get.multimir.by.Table the query seems to still include organism and possibly other parameters in the where clause if no organism is specified. However this isn't valid and is causing long execution times instead of immediately returning an error. There are if statements so if the parameter is null it should be left out of the query. I suspect somewhere it is being set to a ? or somehow defaulting to that. Need to find a way to make sure parameters are excluded when they are invalid.
in get.multimir.by.Table the query seems to still include organism and possibly other parameters in the where clause if no organism is specified. However this isn't valid and is causing long execution times instead of immediately returning an error. There are if statements so if the parameter is null it should be left out of the query. I suspect somewhere it is being set to a ? or somehow defaulting to that. Need to find a way to make sure parameters are excluded when they are invalid.