Re: Using flat file for speed

"Zvonko" <zvonko@xxxxxxxxxxxxx> writes:

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.

Sounds very much like a join on tables in the SQL Server database...?
Which I suspect is likely to be faster than doing it yourself in the
client. (You may have to experiment with the join order and perhaps
build additional indices to get optimal join performance).

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?


--
dt

.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)