Hi All, Please tell me how do i create index for fields, we are using T24 with Oracle database connected via Oracle XML driver
For eg FBNK.FT.BMITPL.OTPASTS is the file name and the plan is to create index for 2 fields CREDIT.VALUE.DATE and DEBIT.VALUE.DATE So can i use the below commands for creating index jsh ->CREATE-EXTINDEX FBNK.FT.BMITPL.OTPASTS CREDIT.VALUE.DATE jsh ->CREATE-EXTINDEX FBNK.FT.BMITPL.OTPASTS DEBIT.VALUE.DATE Regards, Ramkumar.S 2010/11/18 VK <[email protected]> > Hi, > please clarify... If before R09 I had enquiry with fixed selection > which isn't ID, t24 anyway executed SSELECT first? Doesn't make any > sense... > > VK > > On 17 нов, 07:03, Sai Prasanna <[email protected]> wrote: > > Hi, > > > > From R09 onwards there is a feature to disable the SSELECT happening > > automatically in the T24 Enquiries. when we run ENQ <ENQ NAME> it will > give > > u template for putting the selection criteria... in that selection screen > > there is a field to disable the SSELECT and run a Vanilla Select > > > > On Tue, Nov 16, 2010 at 5:22 PM, Ramkumar Sreeni > > <[email protected]>wrote: > > > > > > > > > Hi All, > > > > > I have just made one enquiry and I am able to run execute enquiries, it > is > > > just taking 15 seconds to retrieve the records. Thank you very much to > > > all. Currently i am doing the same way to other enquiries which has > this > > > problem. > > > > > Regards, > > > Ramkumar.S > > > > > On Mon, Nov 15, 2010 at 9:34 AM, Mohankumar Balasubramaniam < > > > [email protected]> wrote: > > > > >> Hi Ram, > > > > >> Please ensure that id should not contain more than 254 characters, > which > > >> also cause performance issue if it is Oracle DB(As of my knowledge). > Try to > > >> have id like TXN_TYPE*CO_CODE*DATE and write FT ids in it and read > records > > >> from actual local template. So that your selection will be easy. also > move > > >> your older records in template with extn .HIS, so file actual file > size will > > >> not be huge, if youy need those old datas then you can read .HIS file > to get > > >> the data. to create index on field use create-index command in > jbase(use > > >> this for ref : > > >>http://www.jbase.com/r5/knowledgebase/manuals/3.0/30manpages/man/adv2. > .. > > >> ) > > >> Do not create index for more than two fields for a file, which also > create > > >> performance issue. > > > > >> *please note: in Jbase @ID is indexed by default so have selection on > id. > > >> it would be better. > > >> * > > >> Regards, > > >> Mohankumar B > > >> On Sat, Nov 13, 2010 at 1:21 AM, Ramkumar Sreeni < > > >> [email protected]> wrote: > > > > >>> Hi Jim, > > > > >>> I meant to say 300 thousand records :), yes SSELECT takes more time > than > > >>> SELECT, but SSELECT is the one which run while we have input the file > > >>> .FT.BMITPL.OTPASTS in the FILE.NAME <http://file.name/> < > http://file.name/> field of > > >>> enquiry. > > > > >>> I just got one solution, that instead of selecting from the fields of > the > > >>> local template, i am writing all the information as part of @ID > itself with > > >>> '.' as delimiter and the SSELECT will be much faster I believe. > > > > >>> How do i create index on a field, please help. > > > > >>> Regards, > > >>> Ramkumar.S > > > > >>> On Fri, Nov 12, 2010 at 12:21 AM, Jim Idle <[email protected] > >wrote: > > > > >>>> Outside India, I doubt that too many people know what a lakh is! J > > > > >>>> However, why are you using SSELECT here? It will be a lot slower > than > > >>>> SELECT I suspect, especially when you come to use the list > afterwards. I > > >>>> think that you have just created a huge query without any indexes > and lots > > >>>> of conditions and it is going to take a long time to do that. Create > some > > >>>> indexes to help this. Maybe on CO.CODE for instance. > > > > >>>> Jim > > > > >>>> *From:* [email protected] [mailto:[email protected]] *On > > >>>> Behalf Of *Ramkumar Sreeni > > >>>> *Sent:* Thursday, November 11, 2010 3:46 AM > > >>>> *To:* [email protected] > > >>>> *Subject:* T24: Select on local template - performance issue > > > > >>>> Hi All, > > > > >>>> We created a report which will list the FT transactions that are > with > > >>>> TRANSACTION.TYPE LK OT..., for outward remittance report, so we > created a > > >>>> local template which will have the list of FT id's from the history > file and > > >>>> also fields which will store information like TRANSACTION.TYPE, > CO.CODE and > > >>>> 9 more fields as these fields are the same fields that will appear > in the > > >>>> enquiry dynamic select criteria, when we run the enquiry, internally > the > > >>>> enquiry is running a select criteria as shown in the mw42 jbase > monitor > > > > >>>> SSELECT F.FT.BMITPL.OTPASTS WITH TRANSACTION.TYPE LIKE OT... AND > CO.CODE > > >>>> EQ BH0010001 etc > > > > >>>> The above select query is taking more time and the browser enquiry > is > > >>>> timing out, since the local template has 3 lakh records. > > > > >>>> Please suggest me a suitable solution so as to avoid browser enquiry > > >>>> getting timed out. > > > > >>>> Regards, > > > > >>>> Ramkumar.S > > > > >>>> -- > > >>>> Please read the posting guidelines at: > > >>>>http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > >>>> IMPORTANT: Type T24: at the start of the subject line for questions > > >>>> specific to Globus/T24 > > > > >>>> To post, send email to [email protected] > > >>>> To unsubscribe, send email to [email protected] > > >>>> For more options, visit this group at > > >>>>http://groups.google.com/group/jBASE?hl=en > > > > >>>> -- > > >>>> Please read the posting guidelines at: > > >>>>http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > >>>> IMPORTANT: Type T24: at the start of the subject line for questions > > >>>> specific to Globus/T24 > > > > >>>> To post, send email to [email protected] > > >>>> To unsubscribe, send email to [email protected] > > >>>> For more options, visit this group at > > >>>>http://groups.google.com/group/jBASE?hl=en > > > > >>> -- > > >>> Please read the posting guidelines at: > > >>>http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > >>> IMPORTANT: Type T24: at the start of the subject line for questions > > >>> specific to Globus/T24 > > > > >>> To post, send email to [email protected] > > >>> To unsubscribe, send email to [email protected] > > >>> For more options, visit this group at > > >>>http://groups.google.com/group/jBASE?hl=en > > > > >> -- > > >> Please read the posting guidelines at: > > >>http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > >> IMPORTANT: Type T24: at the start of the subject line for questions > > >> specific to Globus/T24 > > > > >> To post, send email to [email protected] > > >> To unsubscribe, send email to [email protected] > > >> For more options, visit this group at > > >>http://groups.google.com/group/jBASE?hl=en > > > > > -- > > > Please read the posting guidelines at: > > >http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > > > > IMPORTANT: Type T24: at the start of the subject line for questions > > > specific to Globus/T24 > > > > > To post, send email to [email protected] > > > To unsubscribe, send email to [email protected] > > > For more options, visit this group at > > >http://groups.google.com/group/jBASE?hl=en- Сакриј наведени текст - > > > > - Прикажи текст између наводника - > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
