U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » Community » U++ community news and announcements » Sql: *JoinRef

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: Sql: *JoinRef [message #34975 is a reply to message #34974]

Thu, 22 December 2011 23:10

Didier is currently offline

Didier
Messages: 680
Registered: November 2008
Location: France

Contributor

Hi mirek,

My example was mixed up (I posted it late ...)
What I'm trying to do is the following is use 'join' to
replace the following expression :

Sql * Select(myData).From(TABLE_A)
      .Where(    A_REF_B == Select(B_ID).From(TABLE_B).Where(AGE == xxxxxx) 
              && A_REF_C == yyyyyyy
            );

With the same schema :

TABLE_(TABLE_B)
	INT_    (B_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (AGE)
END_TABLE

TABLE_(TABLE_C)
	INT_    (C_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (WEIGTH)
END_TABLE

TABLE_(TABLE_A)
	INT_    (A_ID) PRIMARY_KEY AUTO_INCREMENT
	INT_    (A_REF_B) REFERENCES(TABLE_B)
	INT_    (A_REF_C) REFERENCES(TABLE_C)
	INT_    (A_SIZE)
END_TABLE

I wan't to do it because I have quite bad performances and maybe using join can speed up things

Report message to a moderator

Send a private message to this user

[Message index]

		Sql: *JoinRef By: mirek on Fri, 09 December 2011 14:14
		Re: Sql: *JoinRef By: Didier on Thu, 22 December 2011 00:22
		Re: Sql: *JoinRef By: mirek on Thu, 22 December 2011 08:17
		Re: Sql: *JoinRef By: Didier on Thu, 22 December 2011 17:26
		Re: Sql: *JoinRef By: Didier on Thu, 22 December 2011 23:10
		Re: Sql: *JoinRef By: mirek on Fri, 23 December 2011 08:40
		Re: Sql: *JoinRef By: mirek on Fri, 23 December 2011 08:48
		Re: Sql: *JoinRef By: Didier on Fri, 23 December 2011 17:24
		Re: Sql: *JoinRef By: mirek on Fri, 23 December 2011 17:26
		Re: Sql: *JoinRef By: mirek on Fri, 10 February 2012 19:12
		Re: Sql: *JoinRef By: Didier on Sat, 11 February 2012 09:31

Previous Topic:	Settings and multiple ide instances
Next Topic:	DataSource

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat Jun 08 12:51:30 CEST 2024

Total time taken to generate the page: 0.01875 seconds