U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » How to display fields from different tables in one SQLArray

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: template + convert problem [message #23169 is a reply to message #23163]

Mon, 21 September 2009 07:34

sergeynikitin is currently offline

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

sergeynikitin@jabber.ru

Zbych wrote on Sun, 20 September 2009 17:47

Quote:

2. This method saves SQL trafic and network speed on Huge Database.

If you have huge database, than you usually don't display everything at once. Beside, I guess, it is faster to send one query with 1000 rows, that 1000 queries with 1 row each.

Quote:

3. View may not be fully compatible with some database engine.

Than you should use databases, that supports views.

What's about decision for notebook+mobile phone. If I use converters, the� users almost do not notice a slow connection, because each row of the table passed 5 integer numbers.

If I use a view or LeftJoin, then each row of the table must be sent to 100 bytes (5 fields of 20 bytes), that is slower to 10 times.

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator

Send a private message to this user

[Message index]

		How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 14:14
		Re: How to display fields from different tables in one SQLArray By: zsolt on Mon, 20 October 2008 14:20
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 14:28
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 14:55
		Re: How to display fields from different tables in one SQLArray By: zsolt on Mon, 20 October 2008 22:51
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 23:00
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Mon, 20 October 2008 23:04
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 14:12
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 16:47
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 16:54
		Re: How to display fields from different tables in one SQLArray By: unodgs on Sun, 02 November 2008 19:09
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 19:41
		Re: How to display fields from different tables in one SQLArray By: unodgs on Sun, 02 November 2008 20:44
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 21:50
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 21:58
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 22:01
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 21:59
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sun, 02 November 2008 22:09
		Re: How to display fields from different tables in one SQLArray By: mirek on Wed, 12 November 2008 22:23
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Thu, 13 November 2008 11:26
		Re: How to display fields from different tables in one SQLArray By: mirek on Sat, 15 November 2008 15:02
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sat, 15 November 2008 15:48
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Fri, 20 March 2009 17:06
		Re: How to display fields from different tables in one SQLArray By: mirek on Sun, 02 November 2008 21:55
		Re: How to display fields from different tables in one SQLArray By: mr_ped on Fri, 20 March 2009 21:37
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Sat, 21 March 2009 08:04
		Re: How to display fields from different tables in one SQLArray By: sergeynikitin on Tue, 07 July 2009 09:47
		template + convert problem By: sergeynikitin on Sat, 19 September 2009 14:22
		Re: template + convert problem By: Zbych on Sat, 19 September 2009 19:30
		Re: template + convert problem By: andrei_natanael on Sat, 19 September 2009 19:59
		Re: template + convert problem By: sergeynikitin on Sat, 19 September 2009 22:45
		Re: template + convert problem By: sergeynikitin on Sat, 19 September 2009 22:37
		Re: template + convert problem By: Zbych on Sun, 20 September 2009 15:47
		Re: template + convert problem By: sergeynikitin on Mon, 21 September 2009 07:34
		Re: template + convert problem By: sergeynikitin on Thu, 30 April 2015 07:55

Previous Topic:	DBF crash error while writing record
Next Topic:	PATCH/BUGFIX Oracle asTable Failure - Solution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun May 12 13:38:46 CEST 2024

Total time taken to generate the page: 0.02787 seconds