[NLP-er]

Originally Posted by imported_silkroad

Also, I wanted to add that if anyone has any ideas how to improve the issues that this mod seems to perform (2) a lot of joins without indexes and (2) write a lot of tmp tables to disk (see screen shots), that would be great :-)

Actually joins are made only if you use selecting by serie (which is configurable) and are joining by serie which is indexed and is a number (so it is very fast to compare).

I see your screen shots and I'm very surprised - you are sure that this is about this mod

Look yourself to product file - each table has index for serie, and look in to vbenterprisetranslator_functions.php on SELECT queries - all 3 which joins tables are using serie to join... Maybe I miss something but I'm still sure that all joins in my mod are made with indexes. So - unless you show me exactly which query causes it I assume that the reason can be in other mod or vB.

About BLOBS. DB is optimized to handle long textes - it means what don't need be in BLOB isn't. Short texts are put into small and medium cache. Long - must be in blob and there is no other way. In SQL you will find VARCHAR(65000) but mySQL will change it to some BLOB or TEXT field. Medium cache is as long as it is possible to be possible to create unique indexes - one char more and unique will not be possible. Also VARCHAR(328) in medium cache statys as varchar. It appears that in older version of mySQL like 4.1.1 it is changed VARCHAR(328) to BLOB, but if someone choose to use old soft which is slower - for me means that he don't need speed, so I optimized it for those who use higher versions

Still - if someone have idea to improve - I will gladly read what solution will make it faster