MySql - Varchar will be faster or Int while sorting -


i have large table , have sort records using tag_id column varchar values numeric in this.

will there performance improvement if convert column datatype varchar integer??

below quesry have write:

select * xxx table order tag_id;


-

Comments

Post a Comment

Popular posts from this blog

sql - MySQL - Finding Empty relations -

i trying work out how full list of team leaders , team members our tables. including team leaders have no team. we have basic data structure have table person contains our basic person object. people extend table in details table. one of extended pieces of information have team_leader status. have 2 relevant details define this: detail_isteamleader , detail_teamleader . first boolean , defines short list of team leaders. second defines persons team leader (ideally subset). _person table_ person_id person_name _detail table_ detail_id detail_person_id detail_isteamleader detail_teamleader i can team leaders have team using following query: select tl.person_id tlref, tl.person_name tlname, per.person_id perref, per.person_name pername detail left outer join person per on detail.person = per.person_id left outer join person tl on detail_teamleader = tl.person_id order tlname, psname however, fails team_leaders detail.isteamleader true not occur in detail_teamleader...
Read more

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

Upload file with tags through OwnCloud or NextCloud API -

i have database of files tagged. now, upload these files owncloud or nextcloud server , pass on existing tags show tags in respective system. wasnt able yet find way how in documentation, have idea how it? thanks! i made available source code of (remote) file tagging micro-service nextcloud on github ( https://github.com/julianthome/taggy ). implementation consists of 2 parts: 1) taggy client uploading files nextcloud server, , invoking taggy server; 2) taggy server adding specified tags uploaded files. i polish code further within next days. planning add ssl support important because username , password transmitted unencrypted taggy server. server uses these credentials in order check whether user can authenticated before tagging files. please let me know if have other ideas, suggestions or feedback ;) kind regards
Read more