Raised This Month: $ Target: $400
 0% 

SQLX Multi-Threaded Questions.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Twilight Suzuka
bad
Join Date: Jul 2004
Location: CS lab
Old 07-08-2006 , 19:53   Re: SQLX Multi-Threaded Questions.
Reply With Quote #1

Quote:
Originally Posted by mysticssjgoku4
Alright, now before I start doing any experimentation and running my-self into the ground before I know enough, I was wondering how the Multi-Threaded queries are sent.

It seems like a good idea, but there are some key issues I wish to verify before switching anything over.


1) What happens when an SQL connection is lost? Will data be lost from that point on?

2) When multi-threading is used, does it queue queries and execute later? What happens the server crashes?

3) When not using Multi-Threading, do the queries queue up?

4) Is there a precise or estimated server advantage of using this over DBI?


Sorry if some of these questions were answered somewhere, but I'm just very curious before doing anything major to my plugins just yet.

Thanks again.
1. Ask BAIL, I think it resolves with a return error.

2. It pushes them into a queue IN ANOTHER THREAD while the top one resolves. If the server crashes, you are screwed. But thats true with ANYTHING.

3. No, they are executed immedietely.

4. Yes. Since the queries are executed in another thread, they don't slow down the server while executing.
__________________
Twilight Suzuka is offline
Send a message via AIM to Twilight Suzuka Send a message via MSN to Twilight Suzuka
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:55.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode