Speed of two large joined access tables!

[horak]

I have a many (~240) field Access table with only a few records in it joined onto another similar table.

Populating these tables takes a long time - for the first record, then it seems to wizz along after that.

Anybody know what might be going on, or if there is a way to speed things up?

Regards,


Alex.

 

[MichaelRed]

Actually, it is a complete suprise (to me at least) that you can get any type of join on two tables where (at least one of them) there are 240 fields. AFAIK, Ms. A has a limit of 255 'fields' for a recordset, but includes indicies in the field count (and possably other info), so the actual join of table this "wide" is not the norm.

Most 'modern' (relational) db engines impose a limit on the # fields in a recordset. I think this is "related" the concept of relational databases, on the idea that there is nothing that cannot be subdivided to smaller (narrower) datasets than is supported by the recordset field limit.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[NickISD]

horak,
your delay (especially with Access 2k) for the first record is where the table is being opened and cached. The subsequent inserts are usually fairly quick. I would however, for performance split the tables down to a more manageable level. This would help in recorset performance. Also with all those fields I would doubt you would ever need all of them returned so only include the fields you actually require when running queries.

Regards, Nick