Hello Helen,

Monday, March 05, 2001, 12:50:18 AM, you wrote:

>>can I find on the Internet a document with some performance tips for Interbase ?

HB> see http://www.interbase2000.org/links.htm, down near the bottom is a download, "Ten Things you can Do to Make InterBase Scream", by Bill Karwin.
HB> See also http://www.ibphoenix.com, in the documentation areas, lots of small and not-so-small papers on various topics.
thanks..pretty useful, especially that paper from Bill Karwin. I'm
also considering now testing firebird...just for speed comparaison.

>>each day. What can I do to improve performance (i'm testing now
>>various indexm but without much improvements) ? What BLOB type should
>>I choose for RTF streams ? (right now the client wants to move into
>>multimedia world and make the database with AUDIO and eventually VIDEO
>>fields...which whould make the whole thing even slower :( ).

HB> Blobs will be slow across the network - if you are making reports containing the blobs, network trafffic will be slowing you down - the more blobs, the slower the reports will be.
yes....I'm redesigning the network right now, putting some SMC
switches, more expensive and hopefully better NICs, and better shielded cables, hoping for the best :)

HB> Oh, and if you are running reports on the same machine as the database, it's a killer. The database wants its own machine and to have the CPU all to itself. Reports hog CPU.
Of course....I've installed the database server on a linux machine and
it runs ok. I'll try a RAID 0 solution to see if I can improve
performance.

thanks


--
Best regards,
Cristian mailto:cris@...