The Arcive of Official vBulletin Modifications Site.

Wayne Luke · #11 07-18-2001, 04:22 AM

Quote:

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.

#12 07-18-2001, 04:45 AM

Alrighty well i do believe i was just owned

I know nothing of oracle, so take the above as a guestimate at best. I should've mentioned that above

The extent of my Oracle knowledge is that its one of the fastest databases, and some extremely simple syntax. I think i'll go back to my corner

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03380 seconds Memory Usage 2,169KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (2)post_thanks_box (2)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (2)post_thanks_postbit_info (2)postbit (1)postbit_onlinestatus (2)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!