My fledgling product is based around a MySQL database. I am looking to change it to SAP DB,
good idea, i like SAPDB although ...
Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can understand the benefits of SAPDB and make the assessment quickly.
... i've hit the limits of SAPDB multiple times, and these limits are quite anoying!
for example a query like
select text from table where length(text)>0
might not work, and SAPDB will throw the error "row to long" because in every table (even in a result-set) the rows are limited to a total length of 8KB, and you can only store long texts, if you use LONG columns, but these are not searchable/indexable/comparable.
if you use long rows in your application, your might hit the row-length-limit very fast!
Does anyone have experience of both platforms, what is your view?
beside the limits of SAPDB, it is a quite good Engine, which supports sub-selects (one one of the things a _real_ DB can't live without).
Is the support as good as MySQL?
if you find a bug in the kernel, you have to wait for the next kernel-release. you might might wait about a month or so, but bugs in the client-API are fixed very fast!
I found a bug in the JDBC driver, and got the fixed version some hours later! (you also fix it yourself of course)
From what I can see, it is a fully featured DB engine, is it as quick as MySQL?
INSERTs/UPDATEs are a bit slow ... SAPDB might as fast as MySQL if you set the LogMode to DEMO (which means, that no transaction-log is written), but that's not a good idea in general.
Queries are executed fast enough, and you don't need to use temporary tables (like most people do, if they have some kind of "complicated" query, which mySQL can't execute directly) because you have sub-selects.
my summary:
- great DB
- fast enough
- supports sub-selects
- supports transactions
- damn stupid small row-length-limit
- no full-text search
(you have to write one yourself, which is easy and will be fast, because you have sub-selects)
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
