Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

~835 People Reached
Favorite Forums
Favorite Tags
Member Avatar for raminshahab

I have three tables that I query. Problem is my ORACLE MIF table has 500,000 rows. And it takes more than 1 hour. How can I reduce the time? SELECT WB_FIELD_REQ.MODEL, WB_FIELD_REQ.MFG_SERIAL_NUMBER, CONFIG_SERIAL_NUMBER, SH_CONTRACTS.EQUIPMENT_ID, "", SH_CONTRACTS.SERVICE, "", SH_CONTRACTS.CONTRACT, "X", "", "X" FROM WB_FIELD_REQ INNER JOIN SH_CONTRACTS ON WB_FIELD_REQ.MFG_SERIAL_NUMBER=SH_CONTRACTS.MFG_SERIAL_NUMBER NOT IN …

0
157
Member Avatar for raminshahab

Array ( [data] => Array ( [0] => Array ( [ucsfeduworkingdepartmentname] => Array ( [0] => ITS ) [telephonenumber] => Array ( [0] => +1 415 502-7575 ) [ucsfeduprofilenodeid] => Array ( [0] => 39487740 ) [displayname] => Array ( [0] => Kevin Dale ) [postaladdress] => Array ( [0] …

Member Avatar for raminshahab
0
236
Member Avatar for raminshahab

I can't seem to get a response from my query method. I have a database connection from method ping_server and use mysqli as connector. Can anyone help me figure out why I cannot print results from mysqli_fetch_array. dbclass.php class db { private $connection; private $selectdb; private $lastQuery; private $config; function …

Member Avatar for raminshahab
0
344
Member Avatar for raminshahab

My issue is this: I call this method twice once inside a function and another in the HTML onclick. Reason is the DIV is part of a context menu. The first function call res is the correct variable I want. The second however changes res b/c Im forced to pass …

Member Avatar for raminshahab
0
98