Website Run By Offsets Query

From: Ben Binskin (brooney_at_bigpond.net.au)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 06:34:08 GMT

hi
    Im just curious, im developing a web site for a client the content of
which is vehicles the database has a number of different methods to search
by, but as soon as you get to a singular vehicle you can browse to the next
/ previous vehicle in the database. To do this i use offsets.

    My question is when i have a page that simply has a list of vehicles,
say the last 5 added for example, the url has to contain the offset value
for that vehicle. So far the only way i can determine to work out the
position of the vehicle in the recordset is to run a search through the
entire table, counting each entry, then once it hits the entry im after it
records the count (hence the offset value i need). Ive set up a function to
determine this for me. My only concern is that once i start displaying the
list of vehicles, hence running the function every time i want to display a
vehicle link, will this place an intolerable load on the server?

Is their an easier way to get the records position in the table? that will
reduce load on the server?

Cheers - Ben.

Relevant Pages

  • Re: Many-to-many relationships
    ... That is what makes it a primary key. ... > a large database project, for purposes of this forum I tend to assume that ... A family with two children could well contain repeating ... > record from the vehicle table and have cascade delete set up you would be ...
    (microsoft.public.access.gettingstarted)
  • Re: Many-to-many relationships
    ... That is what makes it a primary key. ... > database to store terabytes of information or hundreds of millions of records ... A family with two children could well contain repeating information ... > record from the vehicle table and have cascade delete set up you would be ...
    (microsoft.public.access.gettingstarted)
  • ati belit-o ! uite cu ce vine mos gherila !
    ... Using a network of cameras that can automatically read every passing ... By next March a central database installed alongside the Police ... The new national data centre of vehicle movements will form the basis ...
    (soc.culture.romanian)
  • Re: Grids... simple, but I dont know...
    ... In the command window, open your database. ... different vehicle, issue Requery, and then browse. ... I created it putting "myview" in the ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Grids... simple, but I dont know...
    ... In the command window, open your database. ... set the view parameter variable to one vehicle ... I created it putting "myview" in the ...
    (microsoft.public.fox.programmer.exchange)