TDBRichview Vs TRichview

General TRichView support forum. Please post your questions here
Post Reply
poojamulti
Posts: 7
Joined: Sat Apr 01, 2017 6:20 am

TDBRichview Vs TRichview

Post by poojamulti » Sat Apr 01, 2017 6:40 am

Hi Sergei,

My DB has grown to more than 10k records. Each contains RVF Blob (between 10 to 50 A4 size pages of Text). Now, i need to search text in these blobs. Please advice which will be faster i.e. using TDBRichView or TRichView ?

-Sam

PS : Using TRichView since 2006. Working like a charm. :)

Sergey Tkachenko
Site Admin
Posts: 14770
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: TDBRichview Vs TRichview

Post by Sergey Tkachenko » Sat Apr 01, 2017 5:09 pm

TRichView can be faster, because you can skip formatting (the slowest procedure).
Just call rv.LoadRVFFromStream to load from blob streams.
But you cannot use SearchText function, because it selects the result.
Options:
1) You can write your own procedure to enumerate all items and search text in each text item, see http://www.trichview.com/help/controls_ ... items.html
2) You can save text as RVGetTextRange(rv, 0, RVGetTextLength(rv)) and search in this text.

There is one more idea. When you save RVF document, you can create its plain text copy in another field (using RVGetTextRange)). Then you can use some tool allowing full text search in text fields.

poojamulti
Posts: 7
Joined: Sat Apr 01, 2017 6:20 am

Re: TDBRichview Vs TRichview

Post by poojamulti » Thu Apr 06, 2017 9:16 am

Ok. Thanks for the tips Sergei.

Have a nice day !

Post Reply