> I haven't read the whole thread, but shouldn't be better to use blob for > storing this long texts? Sooner or later (everybody known Murphy ;)) > this will not be enough.
No, because of performance issues. Few weeks ago i discussed this problem with Vlad Horsun. There are very big performance problems with TCP and protocols. I profiled native provider with ServerType 0 and 1. You can see that screenshots at http://article.gmane.org/gmane.comp.db.firebird.russian/17822 In general in my case provider works ~27 times slowly with blobs via own protocol: Native implementation with varchars: ~1.5 seconds Native implementation with BLOBS: > 40 seconds !!!! Via fbclient with varchars: ~3.5 seconds Via fbclient with BLOBS: ~5.5 seconds Vlad rewrote my test on Delphi and when he ran it with FB embedded, he saw that internally server works with BLOBS faster, but TCP and client protocol make blobs very slow :-( If you'll at my screenshots from profiler you'll see that in case of native protocol there are no obvious candidate on performance tuning. In case of working via fbclient there are performance problems with marshalling and i do not know is it possible to make something with it or not. Also Vlad wrote that BLOBs can work a little faster in 2.1 thanks to changes in protocol. So we will see... ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
