<div>
Hi,<br><br>What is the database behind this JPA code? Look at the tables and relationship and make sure that proper indexes are in place. <br><br>Regards,<br>&nbsp; &nbsp; &nbsp;Tomas Helgi <br><br>
</div>


Hi,

What is the database behind this JPA code? Look at the tables and relationship and make sure that proper indexes are in place.

Regards,
     Tomas Helgi



<div>
Microsoft sql - I created index for that key but no use&nbsp;
</div>


Microsoft sql - I created index for that key but no use 

Architect

Sathish David  Kumar N

<div>
<div class="content wysiwyg-content fr-view">
<div style=" width: auto; text-align: left;"><a href="https://stackoverflow.com/posts/64855111/timeline" style=" text-align: center;" rel="ugc"></a></div><div style=" width: auto; text-align: left;"><div style=" width: 658.333px;">I have relationship with one to many (parent- child ) relationship. while using JPA save method.<br>Parent have one record child have 5000 to 10000 records . 5k records are in list</div></div><pre style=" width: auto; text-align: left;"><code class="code-1 nolinks" id="code-10-29200594-1">@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinColumn(name = testId")
private List&lt;test&gt; testList;</code></pre><span style=" text-align: left;">Likewise I defined . but while I am saving it take much time . how to reduce the save timing .</span>&nbsp;
</div>
</div>



I have relationship with one to many (parent- child ) relationship. while using JPA save method.
Parent have one record child have 5000 to 10000 records . 5k records are in list
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinColumn(name = testId")
private List<test> testList;
Likewise I defined . but while I am saving it take much time . how to reduce the save timing .
 

performance-issue-of-one-to-many-jpa-records

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.