Hi David, the field is not limited to numeric values.
The following query, where comp is an varchar field, as executed from Tersus:
SELECT * ROM qrtprojectenri_auth WHERE comp>=650 AND comp<=650 ORDER BY id LIMIT 20
returns the resultset within 50 seconds, I tested this query also directly in mysql with the same result, but executing the same query with a small change "650":
SELECT * ROM qrtprojectenri_auth WHERE comp>="650" AND comp<="650" ORDER BY id LIMIT 20
returns the resultset within 2 seconds.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
