[Advanced-java] improving performance of recursive algorithm

[Calin.Vaduva@xxxxxxxxxx (Calin Vaduva)]

Hello Sergio


Before trying to optimize operations you mentioned (in fact the algorithm
process)
you should take care about the modality to work with the data base.
	1. To be sure that you use only one connection to load all data from the
database (most probably yes)
	2. To be sure that you do not use some recursive query with the data base.
	(I mean hear, that base on some data result of one query to make other queries
to the db)
	--> be sure that you load the data from db in one query (at least not too
many). This can 
	be a problem that may affect the performance considerably.
	3. Other optimizations suggested by other repliers..

Regards

Calin


Sergio Luis Sardi Mergen wrote:
> 
> hello list
> 
>  i'm wondering how i can increase the performance of a recursive
> algorithm..It takes data from a database and perform some tasks. It
> takes quite a while to complete the tasks when dealing with a large
> amount of data. The algorithm makes use of:
> 
>  string concatenation
>  type casting
>  use of hashtable/Vector (necessary)
>  use of labels
> 
>  does any of these affect the performance?
> 
>  Some of the above can be removed (with some pain), like the use of
> labels, but i'm afraid i have to use Hashtables and Vectors. But even so
> it would be good to know all that can influence the results.
> 
> thanks very much for helping
> 
> Sergio
> 
> _______________________________________________
> Advanced-java mailing list
> Advanced-java@xxxxxxxxxxxxxxxxxxxxxx
> http://lists.xcf.berkeley.edu/mailman/listinfo/advanced-java