Using flat file for speed

Hi!

I am trying to speed up one point in application by introducing
flat-file database as a frontend for an SQL Server database.
Let me explain. User have to scroll the resultset fetched from SqlServer
database and on every row there is a bunch of queries run to fetch
additional datasets and show result in jLabels. What I would like to try is
to have a flat file database (like Paradox) as a ResultSet and as user
scroll the quering goes to SqlServer (that is the easy part).
What I don't understand is how to maintain the flat file database on
change os SqlServer database. Any info would be apreciated. And if this is
not the right way to speed up the process, what is?


Thanks


.

Relevant Pages

  • Re: Moving full-text index to a different system - problems
    ... What I did was to restore the database into a database which had the db_id I ... > The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... > The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Moving full-text index to a different system - problems
    ... different database server wuthout losing their data or full-text index. ... The Search service has loaded project. ... The Content Index for project <SQLServer SQL0001100005> cannot be loaded. ... The previous crawl was reset, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Access Autonumber problem
    ... Between now and Nov. 6th 2006 you can sign up for a substantial discount. ... primary application that the database uses. ... fairly large customer base. ... In SQLServer the ID ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Importing .dat file
    ... You've obviously never written software for a bunch of clients ... It is not the primary responsibility of my users to do SQLServer. ... would stop using Excel for everything and start using a database; ... mean SQL Server Developers' edition costs $49; ...
    (microsoft.public.dotnet.languages.vb)
  • Re: sqlserver backup & recovery procedures
    ... have rights to the new database. ... >> filename (backup done). ... >> i copied this file to another system running sqlserver ... >> no service packs had been installed for sqlserver 2000. ...
    (microsoft.public.sqlserver.security)