seems slow

[CHAOSinACT]

i've been "growing" a database. build a bit, get feedback, build more on request. working good but notice that forms seem to take forever to save and change between modes, any ideas?

 

[JamesMcS]

Not really enough info to go on there chap. I'd say have a look at your code, see what happens during whatever event seems to be slow, and start from there.

Ususally what I end up doing is getting the database to the point where there's not much feedback any more, then make it again from scratch with the gospel spec, while the users are using the first version. Time consuming but once you've got the whole picture you'll be able to write it in the right way.

 

[ghudson]

Have you compacted your database? Importing all db objects into a new database might help if you suspect there is some corruption in your db.

 

[CHAOSinACT]

yeah it doesn't seem to be code related - opening a blank form has slowed down... The rebuilding idea actually makes me feel slightly nauseous lol but i kind of saw that coming as it just keeps growing. i will compact for now. frankly figuring out everything being used and not used will be a heck of an effort lol. like i said, evolved without a clear plan from client to start with. thanks for the input though, much appreciated.

 

[JamesMcS]

It seems as though once a database gets to a certain size it starts to misbehave.... the suggestion above of importing objects into a blank DB doesn't take that long and would probably be a good place to start, if the code's not causing the problem

 

[PNGBill]

Just a side issue. In my case I am busy inserting my queries into the form, where relevant and then deleting the query.
This tidies the database up a lot.

 

[JamesMcS]

No links in your signature fella. Have to report it....