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: How to display fields from different tables in one SQLArray [message #18974 is a reply to message #18964]

Sun, 02 November 2008 21:55

mirek is currently offline

mirek
Messages: 13976
Registered: November 2005

Ultimate Member

sergeynikitin wrote on Sun, 02 November 2008 10:54

I have a huge table 50000-100000 records. It involves 12-15 reference tables. This is stored in the MySQL server.

What kind of technology would you recommend to work with the database.

Will all the data loaded into memory or the client program will be loaded only a fraction?

Just a funny note: I have just tried what it takes to fetch 130000 records to ArrayCtrl.

It is about 400MB.

Therefore, I would recommend trying the simple path first - do not worry and try it. Maybe the table is not as huge as you think.

You know it, "premature optimization..."

(Well, it definitely is not a huge table. The biggest table I am regulary dealing with has 2 500 000 records Smile

Smile

Mirek

[Updated on: Sun, 02 November 2008 21:56]

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 00:21:40 CEST 2024

Total time taken to generate the page: 0.01648 seconds