java - How to quickly drop a database table content using Spring? -

-

मैं Spring-data-jpa के साथ CrudRepository का उपयोग कर रहा हूं एक पोस्टग्रेज़ डीबी में डेटा जारी रहती है।

दैनिक आधार पर मैं पूर्ण डीबी सामग्री को नवीनीकृत करना चाहता हूं, जिसका अर्थ है कि किसी विशिष्ट तालिका में सभी डेटा को पहले से हटा देना।

< P> रिपॉजिटरी एक विधि dao.deleteAll () प्रदान करता है, लेकिन यह बहुत लंबे समय तक रहता है क्योंकि मेरे पास लगभग 500k प्रविष्टियां हैं।

मैं इसे कैसे सुधार सकता हूं?

< / Div>

आप इकाई प्रबंधक पर मूल एसक्यूएल क्वेरी निष्पादित कर सकते हैं, और अपने डेटाबेस को छोटा कर सकते हैं 

  स्ट्रिंग एसक्यूएल = "TRUNCATE tbl_name;"; entityManager.createNativeQuery (SQL) .executeUpdate ();

Comments

Post a Comment

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr...
Read more

c++ - Qt-how to convert a QByteArray to struct -

-
I need to convert a QByteArray into a structure. I have such a structure: struct mavlink_attitude_t {/// & lt; Summary & gt; Timestamp (millisecond from system boot) & lt; / Summary & gt; Quint 32 Time_boot_ms; /// & lt; Summary & gt; Roll angle (rad, -pi .. + pi) & lt; / Summary & gt; Float roll; /// & lt; Summary & gt; Pitch angle (red, -p + + pi) & lt; / Summary & gt; Boat pitch; /// & lt; Summary & gt; Angle of O (Red, -P. + Pi) & lt; / Summary & gt; Float yao; /// & lt; Summary & gt; Angular Speed ​​Roll (Rod / S) & lt; / Summary & gt; Float rollspeed; /// & lt; Summary & gt; Pitch angular momentum (rad / s) & lt; / Summary & gt; Float pitchspid; /// & lt; Summary & gt; Yoga's angular momentum (RD / S) & lt; / Summary & gt; Float Yspeed; }; And I come from a Quetbeat Serial Port. I was already using the union but I think it can not be used for QByteArray, i...
Read more

c++ - What exceptions does boost mapped_file_source throw? -

-
Boost map_file_source, for example, throws an exception file not found. Is the exception square really throwing it? It does not seem to say in the documentation, unless I miss something. Edit: Test case: #include & lt; Boost / iostreams / device / mapped_file.hpp & gt; Int main (int argc, char ** argv) {boost :: iostreams :: mapped_file_source file; File.open (argv [1]); Return 0; If mapping fails, code mapped_handle_ = :: CreateFileMappingA (handle_, NULL, defense, 0, 0, zero); If (mapped_handle_ == NULL) cleanup_and_throw ("failed to create mapping"); Eventually will boost: iostreams :: detail :: throw_system_failure (msg); i.e. Sub-class of std :: exception In this case, it is std :: ios :: failure : BOOST_IOSTREAMS_FAILURE should be std :: ios_base :: Failure to expand, and otherwise the std :: exception for the appropriate derived class. Reference:
Read more