Large Database - Slow Processing Fixes?

[CAPiTA]

hello,

i am dealing with a very large database of individual part information (n x 100,000 parts). the data only needs to be analyzed by specific part numbers (~50 part numbers), making the amount of data needed at any one time quite a bit less.

i set up a parameter to seperate the data by part number, however it loads the entire database every time i refresh the data for a different part. is there any way around this?

any help is appreciated! thanks!

 

[synapsevampire]

You should post your formula as opposed to describing intent.

Also post your version of software (Crystal and database) with any post in any forum.

The issue is probably that what you have in the Report->Edit Selection Formula->Record probably isn't getting passed to the database.

Check the Database->Show SQL Query for what is being passed.

To limit what is getting passed, it should have something like:

{table.field} = {?MyParameter}

And what does "i set up a parameter to seperate the data by part number" mean?

Do you mean to allow for users to select part numbers? It almost sounds like you're entering them all in one prompt, the parm should probably be a multiple selection and select discrete values.

The key is to ensure that the record selection makes it into the SQL being passed.

-k

 

[CAPiTA]

i am using Crystal Reports Version 8 and the database is Access.

Report->Edit Selection Formula->Record... displays:

{Product.BladeName} = {?ProductID}

"Show SQL Query" was grayed out in the Database menu.

so far, all i have tried is it insert a paramter based on the field Product.BladeName. it was loading only the necessary data for a little while, but i must have changed something and now the preview takes 10-15 min to load every time.

let me know if there is any other information i can provide. forgive my lack of techspeak, this is all very new to me. thanks for the help!

 

[kskid]

If your Show SQL is grayed out, then I suggest that you Click on Database->Verify Database

-LW

 

[CAPiTA]

Verify Database shows the database is up to date.