MySQL Forums
Forum List  »  MySQL Query Browser

Advanced Search
New Topic

Re: Select query with GROUP condition thens order by alphanumeric
Posted by: Chad Bourque
Date: December 14, 2009 07:08PM

chusoon,

It doesn't sound like you really understand what I'm suggesting. :-/ The function to translate a single entry should be fast (very fast). Putting a call to that function on insert and update should not significantly slow down your data entry (even 20 times per day) since your typical data entry should only be updating a single row at a time.

The only slow part to this suggestion is the initial update of existing data (which could be done during off-peak hours).

HTH,
Chad

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.