Saturday 15 May 2010

mysql - Does Longtext slow down queries on other fields? -


I have a website that has user profiles in this website which has a longtex field I'm in a dilemma If I add users and profile tables, does this slow down my query? I have a lot of queries on user tables, these questions are integer and are not related to long text fields, on the other hand, the tables are to be separated but they have 1: 1 There are relationships which are nonsense here.

What to do?

If the columns you are asking are properly indexed, then you should be OK. Avoid

save , and retrieve only long text column when you need it; If there is too much text in it and you do not use it, then you are wasting bandwidth.

No comments:

Post a Comment