|Subject||RE: [firebird-support] Re: Speed issues|
> Params = field values, it is always tof_link_la_typ.lat_typ_id and tof_link_la_typ.lat_ga_id i search, but always with diferent params.OK
> OS is Win7 x64 - its my development machine.That is the right RAM size
> I plan to put database on win2008 R2 x64 server wit 20GB RAM.
> I dont know what is depth of an index.The "depth" is one the value available from running gstat and getting/extracting index details.
> Index is created asI would see what happens if you delete that one and create an index with the order reversed. (You need to delete the current index to ensure that the optimizer choose the right PLAN)
> CREATE INDEX TOF_LINK_LA_TYP_IDX5 ON TOF_LINK_LA_TYP (LAT_GA_ID, LAT_TYP_ID);
What about the suggestion to increase the database page size via restore?? That can make a difference.