store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Mon Oct 14, 2019 9:31 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: MariaDB sends full query to RDBMS through FederatedX
Unread postPosted: Fri Jul 14, 2017 4:16 pm 
Offline
New Forum User
New Forum User

Joined: Fri Jul 14, 2017 4:08 pm
Posts: 1
Location: Houston, TX
Hello all,

We have MariaDB installed and using FederatedX to communicate with a COM component.
Currently when executing ex: select count(*) from tabel1 the COM receives select column1,column2,column3 from table1 and it's returning all rows.
After that the engine is responsible for doing the count function and showing the result.
My question is: How can we change the FederatedX engine to send the full query and not just a simple select?
This same applies if we do select * from table1 where column1=10, runs select column1,column2,column3 from table 1, without the "Where" clause.

Thank you all!

I'm editing this post because 'WHERE' clause is actually solvable by adding Indexes. Problem starts when I'm using Limit or Functions such as Count(*).


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group