473,836 Members | 2,172 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Please help the performance issue.

Hi,
I have wrote the following sql sentence.Do you have comments to improve
the performance.I have created all the indexed. But it's still very
slow.Thanks
The primary key is proj_ID and Task_UID.

SELECT PR.PROJ_NAME AS PRName, PR.PROJ_ID As PRProjID, PR.TASK_UID As
PRTaskUID, 'Dev' AS GroupType,
Feat.PROJ_ID As FeatProjID, Feat.TASK_UID As FeatTaskUID, Feat.FeatureID AS
FeatureID,
dbo.CreateFIDSo rt(Feat.Feature ID) as FIDSort, Feat.FeatureNam e AS
FeatureName, Feat.Entity AS Entity,
Feat.CmtStatus AS CmtStatus, SE.AttrName AS SE, SE.ValueVariant AS SEHRID,
NetworkElement. ValueVariant As NetworkElement,
Pers.FirstName as FirstName, Pers.MiddleInit ial as Middle, Pers.LastName as
LastName,
CASE WHEN Priority.ValueV ariant Is Null Then 9999 When Priority.ValueV ariant
= 0 Then 9999
Else Priority.ValueV ariant END AS Priority, 'Doc' AS DocType, Doc.PROJ_ID AS
DocProjID, Doc.TASK_UID AS DocTaskUID,
Doc.ID_Code AS DocNum, Doc.Entity As DocEnt, DocName.Task_Na me AS DocName,
DocNotes.Task_R TF_Notes AS DocNotes,
DocDetails.Proj _ID AS DateProjID, DocDetails.Task _UID AS DateTaskUID,
DocDetails.Task _Type
AS DetailTaskType, DocDetDates.TAS K_FINISH_DATE AS CWVFinish,
DocDetDates.TAS K_BASE_FINISH
AS BasFinish, DocDetDates.TAS K_ACT_FINISH AS ActFinish, DocDetDur.TASK_ DUR
AS TotalDur, DocDetDur.TASK_ REM_DUR AS RemDur,
DocDetDates.TAS K_ACT_START AS ActStart, Sortnum.DocNum As DocSortNum,
PR.PROJ_NAME AS PR1Name, 'Disp' As FeatDisp

FROM CPR_enum_ReltoP roj Rel WITH (nolock)
INNER JOIN CPR_PATH ReltoFeat with (nolock) ON Rel.PROJ_ID =
ReltoFeat.PRED_ PROJ_ID
AND Rel.TASK_UID = ReltoFeat.PRED_ Task_UID AND Rel.PROJ_NAME LIKE 'R26.0'
AND ReltoFeat.EDGE_ ID = 1
INNER JOIN CPR_TASK_FeatCm tStat Feat WITH (nolock) ON ReltoFeat.SUCC_ PROJ_ID
= Feat.PROJ_ID
AND ReltoFeat.SUCC_ Task_UID = Feat.TASK_UID AND Feat.CmtStatus <> 'Concept'
AND Feat.CmtStatus <> 'Identified'
AND Feat.CmtStatus Is Not Null
LEFT JOIN ( CPR_PATH FeattoPR WITH (nolock)
INNER JOIN CPR_ENUM_PRtoPr oj PR WITH (nolock)
ON FeattoPR.PRED_P ROJ_ID = PR.PROJ_ID AND FeattoPR.PRED_T ASK_UID =
PR.TASK_UID )
ON Feat.PROJ_ID = FeattoPR.SUCC_P ROJ_ID AND Feat.TASK_UID =
FeattoPR.SUCC_T ASK_UID AND FeattoPR.EDGE_I D = 1
LEFT JOIN CPR_ContainerAt tr SE WITH (nolock) ON Feat.PROJ_ID = SE.PROJ_ID
AND Feat.TASK_UID = SE.TASK_UID
AND SE.AttrName in ('SEM','SEA')
LEFT JOIN CPR_Person Pers WITH (nolock) ON Pers.HRID = SE.ValueVariant
LEFT JOIN CPR_ContainerAt tr NetworkElement WITH (nolock) ON Feat.PROJ_ID =
NetworkElement. PROJ_ID
AND Feat.TASK_UID = NetworkElement. TASK_UID AND NetworkElement. AttrName =
'NetElem'
LEFT JOIN CPR_ContainerAt tr Priority WITH (nolock) ON Feat.PROJ_ID =
Priority.PROJ_I D
AND Feat.TASK_UID = Priority.TASK_U ID AND Priority.AttrNa me = 'FPA'
LEFT JOIN ( CPR_PATH FeattoDoc WITH (nolock)
INNER JOIN CPR_ENUM_AllDoc s Doc WITH (nolock)
ON FeattoDoc.SUCC_ PROJ_ID = Doc.PROJ_ID AND FeattoDoc.SUCC_ TASK_UID =
Doc.TASK_UID AND FeattoDoc.EDGE_ ID = 1
AND Doc.ID_Code NOT LIKE '[<]%' AND Doc.Entity in
('FDD','SRD','S RAD','FFRD','VR AD')
LEFT JOIN CPR_DOCSORTNUM Sortnum WITH (nolock) ON Doc.Entity =
Sortnum.DocEnt
INNER JOIN MSP_TASKS DocName WITH (nolock) ON Doc.PROJ_ID = DocName.PROJ_ID
AND Doc.TASK_UID = DocName.TASK_UI D
INNER JOIN CPR_ENUM_Task_R TF_Notes DocNotes WITH (nolock) ON Doc.PROJ_ID =
DocNotes.PROJ_I D
AND Doc.TASK_UID = DocNotes.TASK_U ID
LEFT JOIN ( CPR_PATH DoctoDet WITH (nolock)
INNER JOIN CPR_ENUM_TASK_T ask_Type DocDetails WITH (nolock) ON
(DoctoDet.SUCC_ PROJ_ID = DocDetails.PROJ _ID
AND DoctoDet.SUCC_T ASK_UID = DocDetails.TASK _UID AND DocDetails.Task _Type
In ('WriteRev', 'RwkRFA', 'PubLive', 'Waived','Revie w','RFA', 'CustRev'))
LEFT JOIN MSP_TASKS DocDetDates WITH (nolock) ON
(DocDetails.PRO J_ID = DocDetDates.PRO J_ID AND DocDetails.TASK _UID =
DocDetDates.TAS K_UID)
LEFT JOIN CPR_ENUM_TASK_D urations DocDetDur WITH (nolock)
ON ( DocDetails.PROJ _ID = DocDetDur.PROJ_ ID AND DocDetails.TASK _UID =
DocDetDur.TASK_ UID))
ON ( DocName.PROJ_ID = DoctoDet.PRED_P ROJ_ID AND DocName.TASK_UI D =
DoctoDet.PRED_T ASK_UID AND DoctoDet.EDGE_I D = 1))
ON (Feat.PROJ_ID=F eattoDoc.PRED_P ROJ_ID AND
Feat.TASK_UID=F eattoDoc.PRED_T ASK_UID AND FeattoDoc.EDGE_ ID = 1)
WHERE Feat.FeatureID NOT LIKE '[<]%'
ORDER BY PRName, FIDSort, FeatureID, DocSortNum, DocProjID,DocTa skUID,
DateProjID, DateTaskUID
Dec 9 '05 #1
8 2642
You didn't post your DDL. How about using the Index Tuning Wizard?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Xu, Wei" <xu*@lucent.com > wrote in message
news:dn******** @netnews.net.lu cent.com...
Hi,
I have wrote the following sql sentence.Do you have comments to improve
the performance.I have created all the indexed. But it's still very
slow.Thanks
The primary key is proj_ID and Task_UID.

SELECT PR.PROJ_NAME AS PRName, PR.PROJ_ID As PRProjID, PR.TASK_UID As
PRTaskUID, 'Dev' AS GroupType,
Feat.PROJ_ID As FeatProjID, Feat.TASK_UID As FeatTaskUID, Feat.FeatureID AS
FeatureID,
dbo.CreateFIDSo rt(Feat.Feature ID) as FIDSort, Feat.FeatureNam e AS
FeatureName, Feat.Entity AS Entity,
Feat.CmtStatus AS CmtStatus, SE.AttrName AS SE, SE.ValueVariant AS SEHRID,
NetworkElement. ValueVariant As NetworkElement,
Pers.FirstName as FirstName, Pers.MiddleInit ial as Middle, Pers.LastName as
LastName,
CASE WHEN Priority.ValueV ariant Is Null Then 9999 When Priority.ValueV ariant
= 0 Then 9999
Else Priority.ValueV ariant END AS Priority, 'Doc' AS DocType, Doc.PROJ_ID AS
DocProjID, Doc.TASK_UID AS DocTaskUID,
Doc.ID_Code AS DocNum, Doc.Entity As DocEnt, DocName.Task_Na me AS DocName,
DocNotes.Task_R TF_Notes AS DocNotes,
DocDetails.Proj _ID AS DateProjID, DocDetails.Task _UID AS DateTaskUID,
DocDetails.Task _Type
AS DetailTaskType, DocDetDates.TAS K_FINISH_DATE AS CWVFinish,
DocDetDates.TAS K_BASE_FINISH
AS BasFinish, DocDetDates.TAS K_ACT_FINISH AS ActFinish, DocDetDur.TASK_ DUR
AS TotalDur, DocDetDur.TASK_ REM_DUR AS RemDur,
DocDetDates.TAS K_ACT_START AS ActStart, Sortnum.DocNum As DocSortNum,
PR.PROJ_NAME AS PR1Name, 'Disp' As FeatDisp

FROM CPR_enum_ReltoP roj Rel WITH (nolock)
INNER JOIN CPR_PATH ReltoFeat with (nolock) ON Rel.PROJ_ID =
ReltoFeat.PRED_ PROJ_ID
AND Rel.TASK_UID = ReltoFeat.PRED_ Task_UID AND Rel.PROJ_NAME LIKE 'R26.0'
AND ReltoFeat.EDGE_ ID = 1
INNER JOIN CPR_TASK_FeatCm tStat Feat WITH (nolock) ON ReltoFeat.SUCC_ PROJ_ID
= Feat.PROJ_ID
AND ReltoFeat.SUCC_ Task_UID = Feat.TASK_UID AND Feat.CmtStatus <> 'Concept'
AND Feat.CmtStatus <> 'Identified'
AND Feat.CmtStatus Is Not Null
LEFT JOIN ( CPR_PATH FeattoPR WITH (nolock)
INNER JOIN CPR_ENUM_PRtoPr oj PR WITH (nolock)
ON FeattoPR.PRED_P ROJ_ID = PR.PROJ_ID AND FeattoPR.PRED_T ASK_UID =
PR.TASK_UID )
ON Feat.PROJ_ID = FeattoPR.SUCC_P ROJ_ID AND Feat.TASK_UID =
FeattoPR.SUCC_T ASK_UID AND FeattoPR.EDGE_I D = 1
LEFT JOIN CPR_ContainerAt tr SE WITH (nolock) ON Feat.PROJ_ID = SE.PROJ_ID
AND Feat.TASK_UID = SE.TASK_UID
AND SE.AttrName in ('SEM','SEA')
LEFT JOIN CPR_Person Pers WITH (nolock) ON Pers.HRID = SE.ValueVariant
LEFT JOIN CPR_ContainerAt tr NetworkElement WITH (nolock) ON Feat.PROJ_ID =
NetworkElement. PROJ_ID
AND Feat.TASK_UID = NetworkElement. TASK_UID AND NetworkElement. AttrName =
'NetElem'
LEFT JOIN CPR_ContainerAt tr Priority WITH (nolock) ON Feat.PROJ_ID =
Priority.PROJ_I D
AND Feat.TASK_UID = Priority.TASK_U ID AND Priority.AttrNa me = 'FPA'
LEFT JOIN ( CPR_PATH FeattoDoc WITH (nolock)
INNER JOIN CPR_ENUM_AllDoc s Doc WITH (nolock)
ON FeattoDoc.SUCC_ PROJ_ID = Doc.PROJ_ID AND FeattoDoc.SUCC_ TASK_UID =
Doc.TASK_UID AND FeattoDoc.EDGE_ ID = 1
AND Doc.ID_Code NOT LIKE '[<]%' AND Doc.Entity in
('FDD','SRD','S RAD','FFRD','VR AD')
LEFT JOIN CPR_DOCSORTNUM Sortnum WITH (nolock) ON Doc.Entity =
Sortnum.DocEnt
INNER JOIN MSP_TASKS DocName WITH (nolock) ON Doc.PROJ_ID = DocName.PROJ_ID
AND Doc.TASK_UID = DocName.TASK_UI D
INNER JOIN CPR_ENUM_Task_R TF_Notes DocNotes WITH (nolock) ON Doc.PROJ_ID =
DocNotes.PROJ_I D
AND Doc.TASK_UID = DocNotes.TASK_U ID
LEFT JOIN ( CPR_PATH DoctoDet WITH (nolock)
INNER JOIN CPR_ENUM_TASK_T ask_Type DocDetails WITH (nolock) ON
(DoctoDet.SUCC_ PROJ_ID = DocDetails.PROJ _ID
AND DoctoDet.SUCC_T ASK_UID = DocDetails.TASK _UID AND DocDetails.Task _Type
In ('WriteRev', 'RwkRFA', 'PubLive', 'Waived','Revie w','RFA', 'CustRev'))
LEFT JOIN MSP_TASKS DocDetDates WITH (nolock) ON
(DocDetails.PRO J_ID = DocDetDates.PRO J_ID AND DocDetails.TASK _UID =
DocDetDates.TAS K_UID)
LEFT JOIN CPR_ENUM_TASK_D urations DocDetDur WITH (nolock)
ON ( DocDetails.PROJ _ID = DocDetDur.PROJ_ ID AND DocDetails.TASK _UID =
DocDetDur.TASK_ UID))
ON ( DocName.PROJ_ID = DoctoDet.PRED_P ROJ_ID AND DocName.TASK_UI D =
DoctoDet.PRED_T ASK_UID AND DoctoDet.EDGE_I D = 1))
ON (Feat.PROJ_ID=F eattoDoc.PRED_P ROJ_ID AND
Feat.TASK_UID=F eattoDoc.PRED_T ASK_UID AND FeattoDoc.EDGE_ ID = 1)
WHERE Feat.FeatureID NOT LIKE '[<]%'
ORDER BY PRName, FIDSort, FeatureID, DocSortNum, DocProjID,DocTa skUID,
DateProjID, DateTaskUID
Dec 9 '05 #2
Xu, Wei (xu*@lucent.com ) writes:
I have wrote the following sql sentence.Do you have comments to
improve the performance.I have created all the indexed. But it's still
very slow.Thanks
I am afraid that is very difficult ot give much input given just the
query text. The fact that there are indexes, does not mean that they
are ussed, because they may not be the right indexes.

Normally, I would ask you to post CREATE TABLE and CREATE INDEX statements
for the query, but this is a very complex query, and I doubt that anyone
would actually analyse it to suggest better indexes or any other tweaks.
And it does not help, having no idea what the meaning of the query is.

There is one thing, though, that I can comment about the query:
dbo.CreateFIDSo rt(Feat.Feature ID) as FIDSort,


I don't know how many rows your query returns, but if it returns many rows,
the call to the scalar UDF can be costly. You can always try to take it,
to see what the effect it has.

Apart from that, I can only advice you to look at the query plan and running
the query with SET STATISTICS IO ON, to get an idea of exactly what in the
query that is taking time.

It seems to me that the query plan should start with the condition
CPR_PATH.PROJ LIKE 'R26.0' (change to "=" if you can), provided that
that column is indexed. But this is only a guess on my part, that that
column is selective enough.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 9 '05 #3
how many of your tables have more then 100 rows?

which tables have more then a million rows?

Dec 12 '05 #4
Thanks so much. I use the ASP + Sql Server2000, I guess the problem caused
by so many "left join". There are a lot of data in database now. I have
created some indexes. ( I thinks there are not big problems for this
indexes.) I want create some indexes on views but after my test I found it
is same speed as create the indexes on tables. Hope you can give more help.
Thanks again.
Dec 12 '05 #5
xu,wei (xu*@lucent.com ) writes:
Thanks so much. I use the ASP + Sql Server2000, I guess the problem
caused by so many "left join". There are a lot of data in database now.
I have created some indexes. ( I thinks there are not big problems for
this indexes.) I want create some indexes on views but after my test I
found it is same speed as create the indexes on tables. Hope you can
give more help.


Unfortunately I can only refer to what I said my previous post. There is a
limit of what can be done over newsgroups. Performance tuning a query given
only the query text is impossible - need to know table and indexes for
that. And for a complex query like this, I would need more than so. Even
with access to the database, it can be a difficult task.

I did mention two things you could check:
1) What happens if you exclude the call to the UDF?
2) Is there an index on CPR_PATH.PROJ?

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 12 '05 #6
again, which are teh big tables????

many left joins doesn't cause performance issues.

Dec 13 '05 #7
Hi There,
Some minor suggestions

try not to use LIKE as in this case
AND Rel.PROJ_NAME LIKE 'R26.0'
Replace it with
AND Rel.PROJ_NAME = 'R26.0'
And Try to replace <> as below
AND Feat.CmtStatus <> 'Concept'
AND Feat.CmtStatus <> 'Identified'
AND Feat.CmtStatus Is Not Null

Let us say other CMTStatus which you want to check are
'Stage1','Stage 2' etc
Then You can use
Feat.CmtStatus In ('Stage1','Stag e2',.....)
These are the minor suggestions without looking at the database tables
and other aspects like table size , indexes it would be difficult to
arrive at some conclusion

With Warm regards
jatinder Singh

Dec 15 '05 #8
The tables CPR_PATH,CPR_TA SK_FeatCmtStat more than 100 rows.

The tables Cpr_containerat tr and msp_tasks, cpdr_alldocs more than 1
million row

"Doug" <dr*********@ho tmail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
how many of your tables have more then 100 rows?

which tables have more then a million rows?

Jan 5 '06 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5229
by: Paul Mateer | last post by:
Hi, I have been running some queries against a table in a my database and have noted an odd (at least it seems odd to me) performance issue. The table has approximately 5 million rows and includes the following columns: DocID (INTEGER, PRIMARY KEY, CLUSTERED) IsRecord (INTEGER, NONCLUSTERED)
10
2563
by: **ham | last post by:
I know that's an old dirty issue; GDI+ almost -the slowest part of the framework - has bothered many developers using it in animations. Even in managed C++ the performance is awful. Now, any dude out there does know any thing about this issue in VS 2005 + ..NET 2.0 ? Has Microsoft solved this performance problem, or we will have to again stick to that DX for simple animations in our applications? ( and since Microsoft doesn't support DDraw...
16
1728
by: Ding Lei | last post by:
Dear fellows, I am currently a Java programmer, using it for around 3 years, & felt quite bored with it. IMHO, Java is too strict on lots of things, unlike Perl, There is usually only one or two way to do one thing with Java. Kinda of language I prefer is, elegant syntax, high-speed, wide usage, robust, great degree of freedom. I did learned C quite a long time ago, only a bit though. Not really sure is C the really language approriate?...
13
2774
by: bjarne | last post by:
Willy Denoyette wrote; > ... it > was not the intention of StrousTrup to the achieve the level of efficiency > of C when he invented C++, ... Ahmmm. It was my aim to match the performance of C and I achieved that aim very early on. See, for example "The Design and Evolution of C++". -- Bjarne Stroustrup; http://www.research.att.com/~bs
17
2072
by: 57R4N63R | last post by:
I'm currently building a website for one of the client. There has been few errors here and there, but just recently the problem is getting worse. Basically the symptoms is that when the user try to access the page, it takes really long time to load. However, after up to 1 hour, the website will run fine again as normal. This issue has been there with the site. I usually just ask the system admin to restart the IIS Service. However, the...
4
3274
by: Steph | last post by:
Hi - Trying to chase down a baffling performance issue. Our database has been running very slow lately. So we are performance tuning the database. In doing so, we created a copy of our production database. In that database, I changed one clustered index on a table to try to improve performance. I ran one query - saw a slight improvement - but saw "lazy spool" in the execution plan. I tried to change it back to the original index by...
2
2428
by: Brian Tabios | last post by:
Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So...
2
1571
by: BTabios | last post by:
Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So...
7
1788
by: rn5a | last post by:
This is the second time I am asking this question in this newsgroup since I haven't got a solution or response from anyone in my previous post & I need to resolve this issue desperately. Sorry for the double post but I just didn't have any other option other than re-posting the same question in this newsgroup. Consider the following code in a VB class file: Namespace LoginUserFetchDB Public Class ZForZebra : Inherits SoapHeader
5
2036
by: Varangian | last post by:
Hi, I have a performance issue question? which is best (in terms of efficiency and performance, I don't care neatness in code)... building an ArrayList of Object Instances using SqlDataReader OR using SqlDataAdapter to Fill a DataSet or DataTable ? Thanks!
0
9810
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9656
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10821
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10527
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10571
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10241
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5642
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4441
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4001
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.