Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 20 of 21 total
Thread Multi-Core / Multi-Thread ?
Sat, Jul 20 2013 8:53 AMPermanent Link

Barry

>Might I humbly suggest that by the time any of us actually require such capabilities we will either have retired or
>have sufficient money to pay someone else to worry about it!

+1
We would need customers that were willing to spend at least $5 million+ to develop a database with those capabilities.

Barry
Sun, Jul 21 2013 2:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< Is EDB going to be multi-threaded to gain maximum performance on
multi-core CPUs ? >>

I'm going to answer a question with a question:  how could you possibly be
using ElevateDB all these years and *not* know the answer to that question ?
Smile

Yes, of course it can use multi-core CPUs, just like any other process that
creates multiple threads and doesn't specify any processor affinity.  In
such a case the OS will schedule the execution of the threads as necessary
on each CPU/core.

Tim Young
Elevate Software
www.elevatesoft.com
Sun, Jul 21 2013 2:09 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< Well i'm talking about at engine level using somekind of "Parallelism"
....
http://en.wikipedia.org/wiki/Parallel_computing >>

No, EDB does not do parallel operations.  But, AFAIK, neither does NexusDB,
so I'm not sure what this has to do with your original question.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Jul 22 2013 11:10 AMPermanent Link

Barry

>Yes, of course it can use multi-core CPUs, just like any other process that
>creates multiple threads and doesn't specify any processor affinity.  In
>such a case the OS will schedule the execution of the threads as necessary
>on each CPU/core.

And unlike Microsoft and Oracle, you don't have to pay more for the EDB Server if you are using more CPU's.

Barry
(Gee, I hope I didn't give Tim any ideas <vbg>)
Thu, Aug 8 2013 8:03 AMPermanent Link

Charalampos Michael

Tim,

<<<< Is EDB going to be multi-threaded to gain maximum performance on
multi-core CPUs ?

I'm going to answer a question with a question:  how could you possibly be
using ElevateDB all these years and *not* know the answer to that question ?
Smile>>

I meant the DML Statetments. Eg, Select, JOINs etc using local engine not the EDB Server
Thu, Aug 8 2013 8:06 AMPermanent Link

Charalampos Michael

Tim,

<< Well i'm talking about at engine level using somekind of "Parallelism"
....
http://en.wikipedia.org/wiki/Parallel_computing

No, EDB does not do parallel operations.  But, AFAIK, neither does NexusDB,
so I'm not sure what this has to do with your original question. >>

They writing on their page:

Extraordinary Performance
   Multi-Threaded Engine - utilizes Symmetric Multi-Processor systems to the fullest extent.

Do they mean for their DB Server or DB Local Engine ?
Thu, Aug 8 2013 8:14 AMPermanent Link

Charalampos Michael

Charalampos Michael wrote:

Tim,

<<
No, EDB does not do parallel operations.  But, AFAIK, neither does NexusDB,
so I'm not sure what this has to do with your original question. >>

btw, would be nice to EDB to support parallel operations like SQL Server ?

https://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/

Thank you
Thu, Aug 8 2013 10:20 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Charalampos


>They writing on their page:
>
>Extraordinary Performance
> Multi-Threaded Engine - utilizes Symmetric Multi-Processor systems to the fullest extent.
>
>Do they mean for their DB Server or DB Local Engine ?

Why not ask them?

Roy Lambert
Wed, Aug 14 2013 12:21 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< btw, would be nice to EDB to support parallel operations like SQL Server
? >>

Sure, but we would also charge 20-30 times as much for EDB because I would
have to rewrite it again in order to use parallel operations for sorting,
etc.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Aug 15 2013 5:07 PMPermanent Link

Barry

>Sure, but we would also charge 20-30 times as much for EDB because I would
have to rewrite it again in order to use parallel operations for sorting,
etc.<

Hey Roy,

Do you have your credit card handy?? Smile

Seriously though, will using parallel operations really speed things up that much on a normal machine with say 4 processors? Sure if you had a monster machine with 32 processors, parallel operations would make better use of the processors that otherwise might be underutilized.

But on a busy EDB server with 4 processors, the other 3 processors would be handling other queries. So from my reasoning, if you used 3 or 4 processors in parallel to handle one query on a machine with only 4 processors, the other queries would back up.

So unless you had a lot of processors, parallel operations probably won't make much speed difference.
You'd be far better off cramming as much RAM as possible into the machine.

Just my 2 cents.

Barry
« Previous PagePage 2 of 3Next Page »
Jump to Page:  1 2 3
Image