SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Canned POC - Part II

    With Untold amounts of help from a proprietary guru - ALL credit to Marco - I've finally got to a working stage with the POC.

    The database has been converted from PostgreSQL to Access standalone file format ( mdb ).

    The database contains 290k records in one table, and 12k records in another. The total size is 550ish mb.
    This goes onto a CD.

    Using clientside Javascript, ActiveX and ADODB.Connection ( through Microsoft Jet drivers, apparently ) I'm running queries on the database using stored queries.
    When I run a query to the db on the hard disk - it's fine.
    When i run the POC on the cd - i get a 2 mins + wait the very first time i run a query ... then after that it runs fine.
    We found if you take the cd out and put it back in it has the same problem.
    Also - if you leave it alone for a while - then after about 10, maybe more, minutes... it has the same 2 minute wait - then works normally again.

    The tables have several indexes on them.

    The two questions:

    Considering that the flat file format of the large table in the db is only 39mb - is the reason for the 500+mb the indexing... and is there anyway to reduce this size ?

    Secondly - is the 2 minute delay likely to be caused by some sort of index initialization or something ( I'm new to stand alone proprietary database stuff ) ?
    Is there anyway to STOP this 2 minute wait - coz it's completely prohibitive of any further development right now!

    Thanks

    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---

  2. #2
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Having told Flawless about compacting databases, it's now down to 120MB!

    More news as it happens.....!
    (meanwhile, any suggestions?)
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  3. #3
    Perl/Mason Guru Flawless_koder's Avatar
    Join Date
    Feb 2002
    Location
    Gatwick, UK
    Posts
    1,206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Significant change to the amount of time to burn the CDs ... at any rate

    So ... now i've burned the 120mb version... and tried it...
    Unfortuantely it's showing minimal response to the Repair and Compact.

    Now the initialization time is down to 1 minute 10 seconds.
    That's on a fast machine, with a fairly fast CD-drive.

    Does anyone know what is causing the issue?
    Is it the indexes?
    If so - how can we / can we - fix them???

    Thanks

    Flawless
    ---=| If you're going to buy a pet - get a Shetland Giraffe |=---


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •