RE: [PHP-DB] PHP -> MS SQL (warning, RANT)

Oh dear, if I'm not careful the nickname will stick. Regarding scalability, we are an exceptionally scalable, thread-safe, and tightly coded implementation of the ODBC API spec, delivering an architecture that bypasses the native layer and speaking directly to the Call Level Interface (CLI) of the specific database. Our version 4.0 drivers will take that even further, and be Multi-threaded at all levels (Currently, 3.2 drivers are multi-threaded in the client libraries and request broker, but require additional agent processes to be spawned, or serialized - this usually isn't a problem unless you are running a really low resource db server, but we're eliminating the possibility of a problem there by delivering full multi-threading across all ODBC and JDBC components). We have many (5000+) companies using our drivers in production environments including, high volume websites, ERP, and data integration systems. You do not need to go down to native drivers to support things like transactions either - we actually provide a great deal more functionality than native drivers, as we have fully implemented the ODBC 3.5 API spec as of version 4.0 (3.2 drivers support ODBC 3.5, but do some function mapping). This translates to a rather odd benefit - you can actually enforce additional functionality against your database by using our drivers. Things like additional cursor models are one example. In addition, we typically outperform native drivers by a nice margin, and absolutely smoke some. We are also releasing a benchmarking tool (open source) when we release our 4.0 drivers, called GTKBench. This allows you to horserace any combination of drivers and databases in real time, and in _your_environment_ so you can see actual benefits instead of reading published benchmarks. You get the ability to simulate TPC-A and TPC-C benchmarks, and the code is open (and GPL) so you can extend it as you wish (plus you will see that it's honest when reporting just how much faster we are =) In addition, you get template-based session rules, to add a highly configurable level of security, and not rely on the app or db level to take care of it. Not that anyone here has done it, but gotta love production Oracle servers with scott/tiger logins. ODBC has many many more benefits than people often realize, since their only experience is with db vendor built odbc drivers or Microsoft drivers. There has been quite a bit of talk on this list about database abstraction layers in the programmatic sense. ODBC is the natural compliment to that and may pleasantly surprise you. Anyhow, there is my rant (warned you, didn't I?) I'd be happy to follow up with anyone on or off the list. Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers -----Original Message----- From: Vincent Apesa [mailto:vapesa@hotmail.com] Sent: Thursday, July 13, 2000 4:32 PM To: "Andrew Hill" Subject: Re: [PHP-DB] PHP -> MS SQL Andrew (Mr Openlink), What is the scalability of your software drivers? We would like to deploy Linux/Apache website that will take a good amount of hits. Ideally we would have to move to the native drivers to support things like transactions .. correct? Your feedback would be appreciated. cheers, Vince ----- Original Message ----- From: "Andrew Hill" <ahill@openlinksw.com> Newsgroups: php.db Sent: Thursday, July 13, 2000 3:21 PM Subject: RE: [PHP-DB] PHP -> MS SQL > You can use ODBC :) ODBC is not slow if implemented properly - most people > only know Microsoft's implementation. > Openlink's ODBC drivers are typically faster (sometimes MUCH faster) than > native driver. > You want to look at the Multi-Tier Drivers. > > > More info is available at http://www.openlinksw.com > > Best regards, > Andrew > ---------------------------------------------------- > Andrew Hill > Professional Services Consultant > OpenLink Software > http://www.openlinksw.com > Universal Database Connectivity Technology Providers > > -----Original Message----- > From: Vincent Apesa [mailto:vapesa@hotm@il.com] > Sent: Thursday, July 13, 2000 3:19 PM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] PHP -> MS SQL > > > to bad about PHP4.... > Well, considering I'm using PHP4 are there any other solutions? > > thanks, > Vince > > -- > > Bryan Mattern <bmattern@buytrek.com> wrote in message > > news:9E5AA668748AA6468CA9B3F4E640F29410E7D7@BT02M.buytrek.com... > > Vince, > > > > Take a look at FreeTDS.org. It's *worlds* better, and is much faster than > > ODBC for connecting to SQL server. There are a few tricks listed in the > > FAQ, but the install is easier than the OpenLink install as there is no > > server side installation. I have had problems with php4, but the 3.0.12 > > works fine for my purposes. > > > > If anyone knows why it's incompatible with php4, I would love to know. > > > > --Bryan > > > > ************************* > > Bryan Mattern > > bryan.mattern@datapace.com > > www.datapace.com > > > > > > -----Original Message----- > > From: Vincent Apesa [mailto:vapesa@hotm@il.com] > > Sent: Thursday, July 13, 2000 9:40 AM > > To: php-db@lists.php.net > > Subject: [PHP-DB] PHP -> MS SQL > > > > > > Where can I find some information on how to connect a Linux web server to > a > > MS SQL server? > > > > thanks, > > Vince > > > > -- > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >