×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hello Paul,
Am 03.09.2025 um 02:13 schrieb Paul Nelson <nelsonp@xxxxxxxxxxxxx>:
One should sort the data into the correct order ahead of time. This saves the remote the effort of maintaining the index database.
Depends. If the overall time to run all those steps is slower than pre-sort and insert, there's nothing to win.
I had to explain that the remote machine was working overtime to keep the index database in the proper order.
Interesting remark!
An even less resources wasting approach would have been to completely remove any indexes on the destination database, run the bulk inserts, and then create the desired index in one go. I presume creating an index from an existing table being more efficient than maintaining an index constantly with small changes happening very frequently.
:wq! PoC
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.