You don't have to update your database all at once. You can setup a process
to do it only when new files arrive.
-----Original Message-----
From: Arun Thomas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 11:03 AM
To: [EMAIL PROTECTED]
Subject: Re: Most efficient way to compare two arrays
Is this really more efficient for the kind of query that is required here.
Wouldn't the overhead of inserting all these rows into the database loose
any advantage available from database optimizations?
-AMT
> -----Original Message-----
> From: Tosa, Alex [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 7:06 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Most efficient way to compare two arrays
>
>
> Don't use arrays if performance is important for you. If
> you're building a
> professional application move your data in a database and use
> SQL queries.
>
> -----Original Message-----
> From: Nimmons, Buster [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 8:09 AM
> To: [EMAIL PROTECTED]
> Subject: Most efficient way to compare two arrays
>
>
> I have two arrays each having around 3000 elements. One array
> is a list of
> file names from a database and the other is a list of files on a file
> server. I would like to compare the two arrays and end up
> with two arrays
> showing what was in each array that was not in the other
> array. I am looking
> for the most efficient way to do this since these arrays
> could grow to be
> anywhere from 20,000 to 50,000 in size in the future.
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
> "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set
> JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
=====================================================================
Warning: All e-mail messages sent to or from this address are recorded by
the iPIN corporate e-mail system and may be subject to archival and review.
Furthermore, information in this e-mail may contain privileged or
confidential information and is intended only for the recipient. If you
receive this message in error, notify iPIN immediately by replying to this
message and then deleting it from your computer. Any information in this
e-mail doesn't necessarily reflect the views or opinions of iPIN.
====================================================================.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
