Subject | RE: [firebird-support] Re: Speed issues |
---|---|
Author | |
Post date | 2015-02-07T20:19:10Z |
Sean,
Params = field values, it is always link_la_typ.lat_typ_id and link_la_typ.lat_ga_id i search, but always with diferent params.
OS is Win7 x64 - its my development machine.
I plan to put database on win2008 R2 x64 server wit 20GB RAM.
I dont know what is depth of an index.Index is created as
CREATE INDEX _LINK_LA_TYP_IDX5 ON LINK_LA_TYP (LAT_GA_ID, LAT_TYP_ID);
I hope this helps.
Zoran
Params = field values, it is always link_la_typ.lat_typ_id and link_la_typ.lat_ga_id i search, but always with diferent params.
OS is Win7 x64 - its my development machine.
I plan to put database on win2008 R2 x64 server wit 20GB RAM.
I dont know what is depth of an index.Index is created as
CREATE INDEX _LINK_LA_TYP_IDX5 ON LINK_LA_TYP (LAT_GA_ID, LAT_TYP_ID);
I hope this helps.
Zoran