That is not large enough to create a significant delay (few seconds delay at most on unindexed searches) yet not small enough that the query plan would ignore indexes if present.. an index on a search would definitely be useful.
You didn't say what the search criteria/qualification was.. I'm assuming a table field? Joe ________________________________ From: gok's <[email protected]> To: [email protected] Sent: Tue, March 1, 2011 10:30:19 PM Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas My manager didn't want to move the data structures in to the 7.5 database he want it keep out side but .....user want see only CHG:Change tickets from that 6.3 data....... I want to see only to view the CHG:Change tickets in 7.5 user tool. Joe Martin D'Souza wrote: If the database doesn't have a running AR Server, why not just upgrade it to AR System Server 7.5 by installing one and choosing the upgrade option against that database? That way the data structures will be of the same version.. I do not have a complete idea of what you are trying to achieve - meaning if you want to access this database to just view or modify or ?? So if you can give a little more of what you are trying to achieve I or someone here might have some better views on how to help you.. Joe -----Original Message----- From: gok's Sent: Saturday, February 26, 2011 1:20 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas Hi All, I am trying to query or to search by based on CHG request id from ARSystem 6.3 to ARSystem 7.5. here ARSystem_6_3 database didn't have any ARServer and Mid-tier so I am trying to use Java API ..Here I want some information regarding whether I can get the chg ticket information like related tasks and attachments to ARSystem 7.5. Thanks for replies I do have around 85,370 records .... But I switched to use the vendor form hope this works. Joe DeSouza wrote: How many records do you have in that form? What is the query you are using to query the data in that form? Are the columns used in the criteria of that query indexed in the source data? Joe ________________________________ From: gok's <[email protected]> To: [email protected] Sent: Mon, February 28, 2011 3:45:48 PM Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas Thanks for response Sabyson I worked as you said but when I query any records it is taking a lot of time some times time out error because I need to get related tasks as well and moving the tables which my manger don't want to do it. So i am trying with stored proc to set a parameter value to get the records but is it possible to display the related tasks in the task tab in CHG:Change form. Sabyson Fernandes wrote: You can look into creating a Database link between the 6.3 ARSystem database and the 7.5 ARSystem database. Then create a database SQL view in the 7.5 database that points to the 6.3 database change form. You can then create a view form that points to this DB view and you can access the 6.3 change data from within Remedy 7.5 . Sometimes DB links are slow, so for best results I would just copy the relevant tables into a separate database within the same database instance as your 7.5 database and create the view form on top of that. Hope this helps. Saby --- On Sat, 2/26/11, gok's <[email protected]> wrote: From: gok's <[email protected]> Subject: Re: trying to query ARRemedy 6.3 data from ARserver 7.5.....help me with any ideas To: [email protected] Date: Saturday, February 26, 2011, 8:15 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
