Re: Open append text files for update simultaneously

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

30 users is fine if the FIFO is not going to be too large(thousands of
records). You are not running a long query so you have nothing to worry
about. How many records you expect the FIFO to grow to(not including deleted
records)? If this is for printing, I can't imagine more that a hundred.
There are SQL quires that even run faster than the one I have given you. For
example:

sql = "SELECT MAX(Sequence) AS MaxSeq FROM tblFIFO ORDER BY Sequence"

This will result in 0 or 1 records, with a single "field" named MaxSeq.
There is a MIN function as well. Use the earlier format first because your
code would be simpler and especially if you don't have a lot of records. The
DB does not transport deleted records, and their space is reused for new
records. You don't have to worry about the order of records in the DB,
"ORDER BY" insures that you get your FIFO in the order you expect it to be.
Just make sure that you make Sequence as the primary indexed field for
performance reasons.

It's best to implement your FIFO as a class and add properties and methods
to it. For example:

Public fifo As clsFIFO

fifo.Add "Test"
fifo.Remove "Test"
Debug.Print fifo.Count
etc.

Look for "vb fifo class" to find sample code.



<chook.harel@xxxxxxxxx> wrote in message
news:1129156893.338471.126170@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> The user that will add data can grow to couple of dozens...
> But beacuse like you said its a very easy action (low resource) it
> should end really quick.
>
> Do you mean that if 30 users try to log in on the same time, it'll
> stuck for some of them?
>


.

Relevant Pages

  • Re: Block Rams
    ... Write a sequence of data words into the FIFO, and read them out in the ... synchronous operation in their respective clock domain. ... Even more complex is the decoding of Almost Empty and Almost Full ...
    (comp.arch.fpga)
  • Re: xPC FIFO blocks behaviour.
    ... The fifo read block updates the read index after copying characters to ... return characters if it finds an entire sequence from the specified ... Now i have a new question about fifo reading. ...
    (comp.soft-sys.matlab)
  • Re: Newbie: How to insert facts at prompt?
    ... > derivates of the abstract "FIFO". ... There is only one sequence of clauses, ... Prev by Date: ...
    (comp.lang.prolog)