SitePoint.com

Flawless_koder · Aug 14, 2002, 03:15

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

MarcusJT · Aug 14, 2002, 05:24

Having told Flawless about compacting databases, it's now down to 120MB!

More news as it happens.....!

(meanwhile, any suggestions?)

Flawless_koder · Aug 14, 2002, 06:14

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

Aug 14, 2002, 03:15	#1
Flawless_koder Perl/Mason Guru Join Date: Feb 2002 Location: Gatwick, UK Posts: 1,206	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Aug 14, 2002, 05:24	#2
MarcusJT The doctor is in... Join Date: Jan 2002 Location: London Posts: 3,538	Having told Flawless about compacting databases, it's now down to 120MB! More news as it happens.....! (meanwhile, any suggestions?)

Aug 14, 2002, 06:14	#3
Flawless_koder Perl/Mason Guru Join Date: Feb 2002 Location: Gatwick, UK Posts: 1,206	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