Originally posted by Ratorasniki I think it would be easier to do then you might think. Since all of the database interaction is handled via a class in a self contained file, and the way its called is basically by taking a name from your config file (the one with your sql server, password, database, etc. in it) it might be possible to simple rewrite the existing functions so you would be left with the same functionality, but it would be utilizing a different class, and hence a different database. using the current class as a blueprint, basically.
Actually it is more difficult than that since the Oracle functions are different from the the MySQL ones. For example there is no oracle_query function..
Second Oracle doesn't use Left Join terminology so almost every query has to be rewritten...
Third, Oracle doesn't need a LIMIT command because it can handle data like a database should. It doesn't choke on a few million records in an array like MySQL would. You could implement an approximation of this either in PHP or in Oracle's PL/SQL though.
A truly specatular port would have to take advantage of stored procedures and triggers. Only then would you be able to experience the true power of Oracle and support 10s of thousands of users concurrently on vBulletin.
07-18-2001, 04:22 AM
Threaded Mode