How to use hierarchical query in Infinispan?

Which mysql query is best to use ? In one method I can give an id to each url , in the other method I can put same  url in each row

• I am making a bookmarking site which is the best method? In first method I have to use MySQL JOIN which makes more traffic .But memory will be saved In second method I have to put url in each row which makes use of lot of memory But the query Speed is more as I dont use JOIN or only query will be enough to do

• Answer:

  Your question is a bit unclear in terms of what you mean by "using memory" and the different table schemas you have in mind. In general, it sounds like your question is about normalizing vs. denormalizing data. The answer is going to be application-specific. Look at how often you may need to make use of the data in a normal form (like if other data is connected to it, or for reporting) versus how often you could get by just using the data in a denormalized form. Generally, the benefit of denormalizing data is in specific high-traffic situations where the performance benefit outweighs the other drawbacks of using this database design. However, you may also want to look closely at caching, if the data does not change a lot (many more reads than writes) as that can work well even with normalized data.