|
|
Posted by frizzle on 10/13/54 11:39
pjSoni wrote:
> Hi
>
> Try to do like when admin enters article he should enter <SPLIT> tag
> from where you want break with article so when you read from db try to
> split from split tag.
>
> Regards,
> Jatin
Thanks all for the replies.
I understand what bobzimuta and pjSoni are saying with the intro thing,
but i need two different fields, so the intro in the fulltext can
differ from just te intro.
I think i'll go with Jerry's: SELECT COUNT(id) FROM texttable WHERE
id=1;
But the id of the fulltext would have to match the exact id of the
record with intro and other info?
Would it matter if i added LIMIT 1 to it, so the DB won't go on?
How careful should i be asigning extra indexes? I read somewhere, that
if i asign indexes to fields that aren't going te be updated a lot,
it's not bad, otherwise it would take a lot of time ...
And now i also have second thoughts about my field in the topic records
with the number of replies.
It goes against normalization, but i thought it would save a lot of
calculating time ...
Frizzle.
Navigation:
[Reply to this message]
|