> From: "Peter K. Stys" <[EMAIL PROTECTED]>
> Date: Wed, 25 Oct 2006 11:21:00 -0400
Hi Peter,
> This is an interesting thread. I too built a client-server DB using
> PostgreSQL running on an Xserve and Aliacta's pgsql4rb plugin. It
> runs fine, but I shudder every time I need to update the back-end
> server (so I usually don't). I have text, PICTs, binary data, etc...
> in the DB that is now > 1.5 GB.
I have hear about Valentina users with 4-6 Gb dbs.
> If I had to do it again, would people recommend Valentina as a
> multi-user solution?
Question not to me :-)
> I also need to write a single-user desktop app
> that needs a DB engine. Again, Valentina?
Yes.
You can make with Valentina single user app,
change few lines of code - and get THIS app to be multi-user
Or have simple IF between these few lines of code and have app which is able
work in the same time with local dbs and remote.
> I gather Valentina does not need to "escape" binary data into ASCII
> SQL command strings (true?) so that would make binary data
> transactions much quicker?
Yes. Actually this is true as for binary,
So can be achieved and for strings.
For this you need use SQL binding
:1, :2 ...
Yes avoiding of escape eliminate need
1) spend CPU time and RAM on the client side to produce SQL command
2) less size for network
3) the main -- parser need eat much much less SQL string
4) no need to remove escapes, again win in CPU and RAM.
Also let me point. As we have see, mySQL and Postgre use stream-based
network protocol. In Valentina 2.4 we have implement packet-based protocol.
This allow us do compression of info. Give perfect benefit (7-8 times) for
client-side cursors and other potentially big info.
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
