OpenEMM Support

On second glance it also appears that there is no indexing on the tmp tables created during the import process which slows things considerably as well.

-Austin

I have seen this problem and the single issue is that none of the tables have more than one index on them (primary key) which causes everything to be very slow.

Rule of thumb: If you are looking up a field (column) in WHERE or ORDER BY that field needs to have an index. Yes you can end up with a ...