Information générale
Catégorie:
Codage, syntaxe et commandes
Sorry Gerry,
>>There can be situations where a UDF can simplify what would otherwise be a very complex query.
>>If it looks like a UDF has merit, one tests it with a representative data set; if it performs satisfactorily (considering the alternatives), then one incorporates it.
I've never seen a situation where I couldn't come up with a set of SQL queries (i.e. the base query and a subsequent SELECT or UPDATE) that didn't out perform a UDF in a SQL statement. I not a fan of absolute statements, but in my experience with Fox, this one stands.
I'd be interested in seeing any examples of a UDF in a SQL SELECT that *is* fast.
Regards,
Thom C.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement