Re: LDBC driver

Silvio Bierman wrote:
Agreed. For that reason we advise large-scale users to stay away from MySQL and SQLServer. The generic database handling we have allows us to implement a database-clone action from one provider to the next and we have used that several times to "upscale" users from MySQL or SQLServer to PostgreSQL or Oracle.

We have had to migrate our own ASP platform from MySQL to PostgreSQL when usage levels began to increase.

I would never implement the workarounds you describe for SQLServer in any system if using a different database system is an option in any way. Since our software is a standard system we do not even offer large-scale performance on poorly-scaling database backends.

Interestingly, Silvio, your company's product is exactly the use case that would ostensibly benefit from something like the LDBC driver, if it didn't already have equivalent code in place.

OTOH, from your description it sounds like that level of abstraction was not at all difficult to achieve for you.

I didn't see anything in the LDBC site that would account for the sort of algorithmic adjustments highlighted by Thomas. I suspect that that type of thing will always require a programmer / analyst to pay attention case by case.

That's why they pay us the big bucks / dinero.

--
Lew
.

Relevant Pages

  • Re: LDBC driver
    ... The generic database handling we have allows us to implement a database-clone action from one provider to the next and we have used that several times to "upscale" users from MySQL or SQLServer to PostgreSQL or Oracle. ... We use a reverse proxy for load-balancing purposes on the ASP platform and started with Pound, then moved to yxorp but needed some facilities both could not provide and finally decided to code a reverse proxy servlet ourselves. ...
    (comp.lang.java.databases)
  • Re: MySQL used with VB .NET 1.0
    ... Whatever process you eventually develop for getting the data from an EXCEL spreadsheet on your machine into a database on your ISPs server will be much more complicated than a simple CSV export and FTP. ... I don't think that much people here use MySql as SqlServer Express from Microsoft is freeware. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SqlServer *much* slower waking up than MySQL...change what configs
    ... You can use ALTER DATABASE to set AUTO_CLOSE to OFF ... SqlServer from a PHP page is like 30 seconds to wake up and access the db. ... Same operation with a MySQL is basically instantaneous: ... DBMS, or Visual Studio, and then try to run the website, or vice versa, ...
    (microsoft.public.sqlserver.setup)
  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)