🚀 go-pugleaf

Connect and execute SQL command:

CREATE INDEX IX_MyIndex ON MyTable (Word, Lang)

or, better, add new column ID counter and define PK on it. Counter is 
integer and index on it will require less space than index on string column.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Vladimir Stefanovic" <antivari@po.sbb.co.yu> �������/�������� � �������� 
���������: news:465f19ac@newsgroups.borland.com...
>I have MS Access database/table with attributes:
>
> 1. Word (text)
> 2. Lang (bool)
> 3. Translation (text)
>
> It has 270,000 records.
>
> * Database without any indexes and PKs is about 17MB (6MB compressed)
> * Database *with* just indexes on Word and Lang is about 23MB (8MB 
> compressed)
> * Database *with* PK on Word and Lang is about 23MB (8MB compressed)
> (I suppose that in this case indexes are made by default)
>
> SQL response is dramatically slower without indexes.
>
> I have to deploy this DB with the installation procedure, and I want to
> save this 2MB ( 8MB - 6MB ).
>
> The idea is to deploy the database without idexes and than make composite
> PK (Word+Lang), or just indexes on Word and Lang at run-time, during
> installation procedure.
>
> The question is how to make (composite in this case) PKs or indexes
> at run-time? I'm using ADO.
>
>
>
> -- 
> Best Regards,
> Vladimir Stefanovic
> 

> Connect and execute SQL command:
>
> CREATE INDEX IX_MyIndex ON MyTable (Word, Lang)
>
> or, better, add new column ID counter and define PK on it.
> Counter is integer and index on it will require less space than index
> on string column.

Thank you very much!

Haven't tested it though, but I do not doubt it will work.

The idea with a new Integer PK column is great (I wonder how I
overlooked such solution)!



-- 
Best Regards,
Vladimir Stefanovic