> From: Marco Bambini <[EMAIL PROTECTED]>
> Date: Wed, 1 Mar 2006 20:07:57 +0100
Hi Marco,
> REALSQLServer supports record locking and much more...
:-) you want talk about this?
LOCK RECORD rowid ON TABLE tableName [write privilege on database]
You have implement record locks as SQL command as I have see. Right?
So it is not built into engine.
* Hmm, what about locks in this way of 30K-100K records?
* and I *assume* you must store that "locks" in satellite-table, so other
user will see them...(keep them in RAM is bad-danger), so 30,000 additional
inserts? I feel here huge potential for degradation. Really not interesting.
> and no one database contains indexes in these test.
??? Then sense, Marco ???
You think somebody in real life make dbs without indexes?
Joins without indexes ... better shout into head. :-)
> I am sorry but I am really not interested in raw numbers or flames
> about product that you haven't probably yet tried (and that it isn't
> yet officially released).
Sorry, you have start made claims that REAL server is faster of mySQL.
I know this is not true. Because I *have* try self SqlLite engine, as well
as many other Valentina developers. Results are not impressive. At least for
us.
You develop REAL server as __wrapper__ to that engine. I *assume* you have
add own SQL pre-processor to be able catch your own SQL commands related to
server, other commands you send to SqlLight engine. I hope you will not say
that you have improve SqlLite itself in this way, right? :^)
> I think I'll probably release an open source test suite so anyone can
> make their own test and take their own decisions.
You already have discover at least one major ... lets say mistake of your
test suite.
I repeat 100+1 time on this list. Development of really good benches for db
is hard job. For Mature dbs exists big organizations that do that.
If to make real bench suite, it needs simply bench operation by operation,
from simple to more and more complex. And all operations must be repeated on
different size of dbs to see degradation resistance of DBMS.
--
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>
