Re: Synchronization routine

"Joris Dobbelsteen" <joris.dobbelsteen@xxxxxxxx> (Sun, 30 Oct 2005 21:30:48 +0100):
> Basically I have two lists, one on my firewall and one in a database. The
> list on the firewall must become the same as the list in the database. The
> current sizes are over 1 million entries and I expect to see 2 million rows
> in the future.

Taking into account that you have an old machine, you might be very low
on memory, so this isn't practical. For about one million entries, the
memory consumtion is the same as the size of the individual entries, in
MB! If every entry is 128 bytes in size, then a million entries will
consume roughly 128 MB. And the data size is well under-estimated. You
should consider this.

Regards.


-----
Public key "Ertugrul Soeylemez <never@xxxxxxxxxxxxxx>" (id: CE402012)
Fingerprint: 0F12 0912 DFC8 2FC5 E2B8 A23E 6BAC 998E CE40 2012

HKP: hkp://subkeys.pgp.net/
LDAP: ldap://keyserver.pgp.com/
HTTP: http://www.keyserver.de/

Attachment:pgp23opnzDKPp.pgp
Description: PGP signature

Relevant Pages

  • RE: repeated conversion of data summarized into rows and columns
    ... the database name, table name and field names I used in the code. ... Dim currentUser As String ... ' Column Pointer to work through Hour entries ... Dates and to the HoursDates table and containing a usage entry. ...
    (microsoft.public.excel.misc)
  • Re: Multiple Record Inputs with one Form
    ... For intCount = 1 To Me! ... the entries from the form inputed. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)
  • Re: Commas in URLs?
    ... > entries are also commonly used for this purpose, ... > used bibliographic database app EndNote has a "URL" field in each entry. ... > the multiple keywords in EndNote Keywords field, ... > delimiter for individual keywords in that field is the comma. ...
    (comp.infosystems.www.authoring.html)
  • New Shareware: MyIdeasJournal version 1.1
    ... MyIdeasJournal is a database program that you can use to capture ... Searching for entries by subject is also very easy and fast. ... listbox item. ... you are either in Search mode or in Browse mode. ...
    (comp.software.shareware.announce)
  • Re: Multiple Record Inputs with one Form
    ... Dim strSQL As String ... Lets say we start out with two entries. ... "Jeff Boyce" wrote: ... database will let you do. ...
    (microsoft.public.access.formscoding)