Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 10, 2012 03:22 AM by hariyaano
Mar 10, 2012 02:20 AM|LINK
If for example I have a table:
--- IdString DText - Dsource
(Int) (text) (text)
In 99% of the time I recover DText and only 1% of the time I recover Dsource.
Dtext and dsource (DText and DSource are big texts).
SELECT DText FROM tblstrings WHERE id = n
SELECT DSource FROM tblstrings WHERE id = n
If I split the table in two parts I'll have to search more efficiently?
--- IdString DText
FK_IdString - Dsource
Someone with a theoretical basis on the database can give an opinion? (table size x performance)
As always thank you very much.
Mar 10, 2012 03:22 AM|LINK
You can go for URL rewriting